Question

Why is ORDER BY clause used with SELECT statement?

Answer 1

The ORDER BY clause is used to sort the fetched data in a specific order either ascending or descending.

Syntax:

SELECT column-list     

FROM table_name     

[WHERE condition]     

[ORDER BY column1, column2, .. columnN] [ASC | DESC];