Question

You use the ____ clause to list data in a specific order.â

Answer 1

ORDER BY clause.

In a SELECT statement, this SQL clause is used to sort result set based data on several columns in a descending or an ascending order. The default syntax for using this clause to sort data is shown as below:

SELECT column-list
FROM table_name [WHERE condition]
[ORDER BY column1 [, column2, .. columnN] [DESC]];