The ORDER BY keyword is used to sort the data in a recordset.
The ORDER BY keyword sort the records in ascending order by default.
If you want to sort the records in a descending order, you can use the DESC keyword.
To learn more about SQL, please visit our SQL tutorial.
The Below example selects all the data stored in the "Persons" table, and sorts the
result by the "Age" column:
The output of the code above will be:
It is also possible to order by more than one column. When ordering by more than one column, the
second column is only used if the values in the first column are equal:
Your Query was successfully sent!