The result of a query can be sorted by using the optional _________ clause.
A)ORDER BY
B)ORDER
C)SORT BY
D)SORT

Question

Quizplus · Accepted Answer

ORDER BY clause is used to sort the result sets in ascending or descending order based on one or more columns. It is an optional clause in SQL that can be combined with SELECT, UPDATE, DELETE, or even with sub-queries. The syntax for the ORDER BY clause is "ORDER BY column_name [ASC | DESC]".

The Result of a Query Can Be Sorted by Using