?
Which SQL keyword is used to sort the result-set?
Answer & Solution
Correct Answer:
Option
C
The SQL keyword used to sort the result-set in a specific order is
Option A:
There is no standard SQL keyword called
Option B:
The
Option C:
The
Option D:
So, the correct SQL keyword to sort the result-set is
ORDER BY. Here's a brief explanation of each option:Option A:
SORT BYThere is no standard SQL keyword called
SORT BY for sorting result-sets.Option B:
ORDERThe
ORDER keyword, by itself, is not used to specify the sorting of a result-set. It's typically used in combination with BY as ORDER BY.Option C:
ORDER BYThe
ORDER BY clause is used to specify the sorting of the result-set based on one or more columns. You can use it to sort the result-set in ascending or descending order.Option D:
SORTSORT is not a standard SQL keyword used for sorting result-sets. The correct keyword is ORDER BY.So, the correct SQL keyword to sort the result-set is
Option C: ORDER BY.
Join the Discussion
Login to post a comment or share your explanation.
Login