Retrieve Top 100 Rows from a Table
Which one of the following statements should you use to return
only the 100 rows from the Master table?
Select Answer:
A. SELECT * FROM Master WHERE count(*) = 100
B. SELECT 100 FROM Master
C. SELECT TOP(100) FROM Master
D. SELECT count(100) FROM Master
E. SELECT TOP 100 * FROM Master
|