ORDER BY clause

The ORDER BY helps us in retrieving records in an ordered manner. This provides sorted data on a particular column in an ascending or a descending manner. By default, it will sort in ascending order but we can also explicitly specify the sorting manner with ASC and DESC keyword. If we specify ASC then it will sort in an ascending order while DESC keyword will sort in descending order. Here is the query which will find all users in a sorted manner in an ascending order on city column.

SELECT * FROM users ORDER BY city ASC;

Sorting in multiple columns is also possible using ORDER BY clause. We can pass multiple columns as shown in below query where we have ordered by city and username column.

SELECT * FROM users ORDER BY city, username;