MYSQL ORDER BY

 

MYSQL ORDER BY clause

When you use the SELECT statement to query data from a table, the result set is not ordered. It means that the rows in the result set can be in any order.

To sort the result set, you add the ORDER BY clause to the SELECT statement. 

The SQL ORDER BY clause is used to sort the records in the result set for a SELECT statement.

The syntax for using ORDER BY -:

SELECT expressions

FROM tables

[WHERE conditions]

[GROUP BY <COL_NAME>

HAVING <CONDITION ON GROUPS>]

ORDER BY COL1,COL2,.. [ ASC | DESC ];

ASC –:

 Ascending order by COLUMNS [Default]

DESC – :

Descending order by COLUMNS

Note -:

ORDER BY clause is always evaluated after the FROM and SELECT clause.