Question

Which clause is used to sort the records in ascending and descending order?

Answer 1

Explanation:

Order by clause is used with SELECT statement for arranging retrieved data in sorted order. The Order by clause by default sorts the retrieved data in ascending order. To sort the data in descending order DESC keyword is used with Order by clause.