What does COUNT(column) do differently from COUNT(*)?
- A It skips rows where that column is NULL
- B It counts distinct values
- C It is faster in all cases
- D It includes NULLs explicitly
Answer
It skips rows where that column is NULL
This distinction silently changes results and is a frequent source of numbers that do not reconcile.





