            Coding With Fun

Home Docker Django Node.js Articles Python pip guide FAQ Policy

SQL ORDER BY Keywords by Keywords

May 16, 2021 SQL

1. SQL ORDER BY keyword

2. Demonstrate the database

3. ORDER BY instance

4. ORDER BY DESC instance

5. ORDER BY Multi-Column Instance 1

6. ORDER BY Multi-Column Instance 2

7.. Chapter test

SQL ORDER BY keyword

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.

SQL ORDER BY syntax

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.

Demonstrate the database

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

ORDER BY instance

The following SQL statement picks all customers from the "Customers" table and sorts them by the "Country" column:

SELECT * FROM Customers
ORDER BY Country;

ORDER BY DESC instance

The following SQL statement picks all customers from the "Customers" table and sorts them in descending order of the "Country" column:

SELECT * FROM Customers
ORDER BY Country DESC;

ORDER BY Multi-Column Instance 1

The following SQL statement picks all customers from the "Customers" table and sorts them by the "Country" and "CustomerName" columns:

SELECT * FROM Customers
ORDER BY Country, CustomerName;

ORDER BY Multi-Column Instance 2

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;

Chapter test

For more questions, please refer to: SQL Quiz Library