Intermediate
SQL
Q70 / 100
What does "SELECT TOP 10 PERCENT * FROM table ORDER BY score DESC" (SQL Server syntax) accomplish?
Correct! Well done.
Incorrect.
The correct answer is B) Returns the top 10% of rows (by row count) from the table, ordered by score descending
B
Correct Answer
Returns the top 10% of rows (by row count) from the table, ordered by score descending
Explanation
TOP n PERCENT returns approximately that percentage of the total row count, here the highest-scoring 10% after sorting.
Progress
70/100