Which SQL keyword is used to sort the result-set?

Question

a. SORT BY

b. ORDER

c. ORDER BY

d. SORT

Answer 1

The correct answer is option B (ORDER BY). ORDER BY keyword is used to sort the result-set and we can sort in either ascending or descending order. Here is the syntax to use ORDER BY keyword in SQL:

SELECT column_list
FROM TableNam
ORDER BY column_list ASC|DESC;

Here is the query if you want to sort the employees according to the salaries in the employee table.

SELECT Employee_name, Salary

FROM Employee

ORDER BY Salary

In case you want to learn SQL, then register for this SQL training course by Intellipaat that provides instructor-led training, certification, and also job assistance.