How do you find the total number of rows in a table ?
-
SELECT COUNT *
-
SELECT COUNT(*)
-
SELECT COUNT[*]
-
SELECT COUNT(ALL)
B
Correct answer
Explanation
COUNT(*) is the correct SQL aggregate function syntax to count all rows in a table. The asterisk must be in parentheses. COUNT * (A) is invalid syntax, COUNT* uses wrong brackets, and COUNT(ALL) (D) is not the standard way to count rows.