To count the number of rows in a table,use the SQL construct ________.
A)SELECT *
B)SELECT TOP n *
C)SELECT COUNT(TOP n)
D)SELECT COUNT(*)

Name: To count the number of rows in a table,use the SQL construct ________. A)SELECT * B)SELECT TOP n * C)SELECT COUNT(TOP n) D)SELECT COUNT(*)
Brand: Quizplus
Rating: 4.8 (39 reviews)

Question

Quizplus · Accepted Answer

To count the number of rows in a table, the SQL construct 'SELECT COUNT(*)' should be used. This will count all the rows in the table and return a single value as the result.

To Count the Number of Rows in a Table,use the SQL