SQL ORDER BY keyword

The ORDER BY keyword is used to sort the result set.

SQL ORDER BY keyword

The ORDER BY keyword is used to sort the result set by a column or columns.
The ORDER BY keyword sorts the records by default. If you need to sort the records in descending order, you can use the DESC keyword.

SQL ORDER BY syntax

SELECT column_name , column_name
FROM table_name
ORDER BY column_name , column_name ASC|DESC;



Demo database

In this tutorial, we will use the RUNOOB sample database.
The following is the data selected from the “Websites” table:
 + ---- + -------------- + --------------------------- + - ------ + --------- +
| Id | name | url | alexa | country |
+ ---- + -------------- + --------------------------- + - ------ + --------- +
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | Taobao | https://www.taobao.com/ | 13 | CN |
| 3 | rookie tutorial | http://www.runoob.com/ | 4689 | CN |
| 4 | microblogging | http://weibo.com/ | 20 | CN |
5 | Facebook | https://www.facebook.com/ | 3 | USA |
+ ---- + -------------- + --------------------------- + - ------ + --------- +

ORDER BY instance

The following SQL statement selects all sites from the “Websites” table and sorts them according to the “alexa” column:

Examples

SELECT * FROM Websites ORDER BY Alexa
Execute the output:



ORDER BY DESC instance

The following SQL statement selects all sites from the “Websites” table and sorts them in descending order of “alexa”

Examples

SELECT * FROM Websites ORDER BY Alexa DESC ;
Execute the output:



ORDER BY multiple columns

The following SQL statement selects all sites from the “Websites” table and sorts them according to the “country” and “alexa” columns:

Examples

SELECT * FROM Websites ORDER BY Country , alexa
Execute the output:

Leave a Reply

Your email address will not be published. Required fields are marked *