Order by

The ORDER BY clause expresses the order in ascending or descending
order.

If we do not define ORDER BY in the statement, it is alphabetically by
default (ascending).

Structure:

SELECT column_name
FROM table_name
ORDER BY column_name ASC|DESC;

 

Example1:

We have a table Customer with this data:

 

SELECT name
FROM Customer
ORDER BY name asc;

 

Example2:

SELECT name
FROM Customer
ORDER BY name desc;

 

Example3:

SELECT disctinct name
FROM Customer
ORDER BY name desc;