Q
Which statement about COUNT is correct?
-
A
COUNT(*) counts all rows, while COUNT(column) ignores NULL values
-
B
COUNT(*) ignores NULL values
-
C
COUNT(column) counts NULL values
-
D
COUNT works only with numbers
Correct Answer:
A. COUNT(*) counts all rows, while COUNT(column) ignores NULL values
Explanation:
COUNT(*) counts every row; COUNT(column) counts only rows where the column is not NULL.
