MariaDB ORDER BY clause is used with the MariaDB SELECT statement to sort or re-arrange the records in the result set.

Syntax:

SELECT expressions
FROM table_name
WHERE conditions;
ORDER BY expression [ ASC | DESC ];


Parameters:
ASC: It is an optional parameter which is used to specify the sorting order to sort records in ascending order. By default the result set is sorted in ascending order with ORDER BY clause.
DESC: It is an optional parameter which is used to specify the sorting order to sort records in descending order.

Example 1: Default order.
Players table:

ID	NAME	        SPORTS
1	Sachin	        Cricket
2	Dhoni	        Cricket
3	Sunil	        Football
5	Mary	        Boxing


Query:

SELECT * FROM Players WHERE id > 2 ORDER BY name;

Output:

ID	NAME	        SPORTS
5	Mary	        Boxing
3	Sunil	        Football


Explanation:
The ‘players’ is an already existing table. Here we are selecting all the fields from the table with a condition that the selected row must have an ID greater than 2. Here we are asking the ORDER BY clause to order the result set by NAME in ascending order by default.

Example 2: Ascending order.
Players table:

ID	NAME	        SPORTS
1	Sachin	        Cricket
2	Dhoni	        Cricket
3	Sunil	        Football
5	Mary	        Boxing


Query:

SELECT * FROM Players WHERE id > 2 ORDER BY name ASC;

Output:

ID	NAME	        SPORTS
5	Mary	        Boxing
3	Sunil	        Football


Explanation:
The ‘players’ is an already existing table. Here we are selecting all the fields from the table with a condition that the selected row must have an ID greater than 2. Here we are asking the ORDER BY clause to order the result set by NAME in ascending order.

Example 3: Descending order.
Players table:

ID	NAME	         SPORTS
1	Sachin	         Cricket
2	Dhoni	         Cricket
3	Sunil	         Football

SELECT * FROM Players WHERE id > 2 ORDER BY name DESC; </re>   <strong><em>Output: </em></strong> <pre> ID NAME SPORTS 3 Sunil Football 4 Srikanth Badminton 5 Mary Boxing