Which statement best describes the effect of TOP 10 in a SQL query after an ORDER BY clause?

Which statement best describes the effect of TOP 10 in a SQL query after an ORDER BY clause?

• A. It returns the first 10 rows from the result set after ordering
• B. It returns 10 random rows
• C. It returns 10 rows with maximum values only
• D. It returns 10 rows after grouping

Answer: (A)

Top 10 takes the result of a query, sorts it with ORDER BY, and then keeps only the first ten rows of that ordered list. The order you specify (ascending or descending) decides which rows appear in those first ten—ascending gives the smallest values first, descending gives the largest. It’s not about randomness and not about grouping unless you introduce grouping in a subquery; without ORDER BY, TOP could return any ten rows. For a concrete picture, choosing the top ten by a date column in descending order returns the most recent ten rows.

Top 10 takes the result of a query, sorts it with ORDER BY, and then keeps only the first ten rows of that ordered list. The order you specify (ascending or descending) decides which rows appear in those first ten—ascending gives the smallest values first, descending gives the largest. It’s not about randomness and not about grouping unless you introduce grouping in a subquery; without ORDER BY, TOP could return any ten rows. For a concrete picture, choosing the top ten by a date column in descending order returns the most recent ten rows.