Multiple choice technology databases

  1. Which SQL keyword is used to sort the result-set? SORT BY ORDER BY SORT ORDER

  1. SORT BY

  2. ORDER BY

  3. SORT

  4. ORDER
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The ORDER BY keyword is the standard SQL clause used to sort the result-set of a query in ascending or descending order.

AI explanation

To answer this question, you need to understand SQL queries and the keyword used to sort the result-set.

Option A) SORT BY - This option is incorrect because there is no such keyword in SQL.

Option B) ORDER BY - This option is correct. The "ORDER BY" keyword is used in SQL to sort the result-set in ascending or descending order based on one or more columns.

Option C) SORT - This option is incorrect because there is no "SORT" keyword in SQL.

Option D) ORDER - This option is incorrect because "ORDER" alone is not a valid keyword to sort the result-set in SQL.

The correct answer is B) ORDER BY. This option is correct because "ORDER BY" is the keyword used in SQL to sort the result-set.

Keep practicing — related questions