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

Question

Quizplus · Accepted Answer

The SQL construct "SELECT TOP n *" limits the number of rows retrieved to the top n rows. This is the best choice as it specifically addresses the requirement to limit the number of retrieved rows. Choice A (SELECT *) retrieves all rows, while choices C, D, and E (SELECT COUNT(TOP n), SELECT COUNT(*), and SELECT COUNT *) all perform row counts rather than limiting the number of rows retrieved.

To Limit the Number of Rows Retrieved from a Table,use