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
SELECT COUNT() is the correct SQL syntax for counting all rows in a table. Option A is missing parentheses, C uses incorrect brackets, and D is not valid syntax for counting all rows. COUNT() counts all rows including NULLs.