You can use multiple columns in the OLD BY clause, but make sure that the columns used to sort the columns are in the list.
May 16, 2021 SQL
The ORDER BY keyword is used to sort the result set in ascending or descending order.
The ORDER BY keyword sorts records in ascending order by default.
If you need to sort records in descending order, you can use the DESC keyword.
SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;
You can use multiple columns in the OLD BY clause, but make sure that the columns used to sort the columns are in the list.
In this tutorial, we'll use the famous Northwind sample database.
Here's the data from the Customers table:
CustomerID | CustomerName | ContactName | Address | City | PostalCode | Country |
---|---|---|---|---|---|---|
1
|
Alfreds Futterkiste | Maria Anders | Obere Str. 57 | Berlin | 12209 | Germany |
2 | Ana Trujillo Emparedados y helados | Ana Trujillo | Avda. de la Constitución 2222 | México D.F. | 05021 | Mexico |
3 | Antonio Moreno Taquería | Antonio Moreno | Mataderos 2312 | México D.F. | 05023 | Mexico |
4
|
Around the Horn | Thomas Hardy | 120 Hanover Sq. | London | WA1 1DP | UK |
5 | Berglunds snabbköp | Christina Berglund | Berguvsvägen 8 | Luleå | S-958 22 | Sweden |
The following SQL statement picks all customers from the "Customers" table and sorts them by the "Country" column:
The following SQL statement picks all customers from the "Customers" table and sorts them in descending order of the "Country" column:
The following SQL statement picks all customers from the "Customers" table and sorts them by the "Country" and "CustomerName" columns:
The following SQL statement selects all customers from the Customers table, in ascending order of "Country" and in descending order of the "CustomerName" column:
SELECT * FROM Customers
ORDER BY Country ASC, CustomerName DESC;
For more questions, please refer to: SQL Quiz Library