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


Correct Option: B

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.

Find more quizzes: