{"id":13724,"date":"2023-12-29T00:19:28","date_gmt":"2023-12-29T07:19:28","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=13724"},"modified":"2023-12-29T00:19:29","modified_gmt":"2023-12-29T07:19:29","slug":"mysql-order-by","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-order-by\/","title":{"rendered":"MySQL ORDER BY"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to sort the rows in a result set using the MySQL ORDER BY<\/code> clause.<\/p>\n\n\n\n

Introduction to the MySQL ORDER BY clause<\/h2>\n\n\n\n

When you use the SELECT<\/a><\/code> statement to query data from a table, the order of rows in the result set is unspecified. <\/p>\n\n\n\n

To sort the rows in the result set, you add the ORDER BY<\/code> clause to the SELECT<\/code> statement. <\/p>\n\n\n\n

The following illustrates the syntax of the ORDER BY<\/code> clause:<\/p>\n\n\n

SELECT<\/span> \n   select_list\nFROM<\/span> \n   table_name\nORDER<\/span> BY<\/span> \n   column1 [ASC<\/span>|DESC<\/span>], \n   column2 [ASC<\/span>|DESC<\/span>],\n   ...;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, you specify the one or more columns that you want to sort after the ORDER BY<\/code> clause.<\/p>\n\n\n\n
The ASC<\/code> stands for ascending and the DESC<\/code> stands for descending. You use ASC<\/code> to sort the result set in ascending order and DESC<\/code> to sort the result set in descending order.<\/p>\n\n\n\n
This ORDER BY<\/code> clause sorts the result set by the values in the column1<\/code> in ascending order:<\/p>\n\n\n
ORDER BY column1 ASC;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
And this ORDER BY<\/code> clause sorts the result set by the values in the column1<\/code> in descending order:<\/p>\n\n\n
ORDER BY column1 DESC;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
By default, the ORDER BY<\/code> clause uses ASC<\/code> if you don’t explicitly specify any option. Therefore, the following ORDER BY<\/code> clauses are equivalent:<\/p>\n\n\n
ORDER BY column1 ASC;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
and<\/p>\n\n\n
ORDER BY column1;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
If you want to sort the result set by multiple columns, you specify a comma-separated list of columns in the ORDER BY<\/code> clause:<\/p>\n\n\n
ORDER BY\n   column1,\n   column2;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this case, the ORDER BY<\/code> clause sorts the result set by column1<\/code> in ascending order first and sorts the sorted result set by column2<\/code> in ascending order.<\/p>\n\n\n\n
It is possible to sort the result set by a column in ascending order and then by another column in descending order:<\/p>\n\n\n
ORDER BY\n    column1 ASC,\n    column2 DESC;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this case, the ORDER BY<\/code> clause:<\/p>\n\n\n\n