SQL ORDER BY

The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns.

• We can use the keyword DESC to sort the data in descending order.
• And the keyword ASC to sort in ascending order.

ORDER BY Syntax

SELECT * FROM table_name
ORDER BY column_name1, column_name2,... ASC|DESC;

Sort according to multiple columns

SELECT * FROM table_name
ORDER BY column_name1 ASC|DESC, column_name2,... ASC|DESC;

Student Table

A table of student records, the name of table is "Student", and the name of columns are [ROLL_NO, STUDENT_NAME, ADDRESS, MOBILE_NO, AGE, and BRANCH]:

ORDER BY Example

ORDER BY DESC

SELECT * FROM Student
ORDER BY Age DESC;

OrderBy DESC, Age from Student Table

ORDER BY Multiple Columns

SQL statement selects all Students from the "Student" table, sorted by the "Student_Name" and the "Age" column. That means it orders by Student_Name, but if some rows have the same Student_Name, it orders them by Age;

SELECT * FROM Student
ORDER BY Student_Name, Age;

Result OrderBy Multple Columns

ORDER BY Multiple Columns ASC|DESC

SELECT * FROM Student
ORDER BY Student_Name ASC, Age DESC;