MySQL ORDER BY: Sorting Query Results in Ascending & Descending Order

The ORDER BY clause in MySQL is used to sort the result set in ascending (ASC) or descending (DESC) order based on one or more columns.

Syntax:

SELECT column1, column2 FROM table_name 
ORDER BY column1 [ASC | DESC];

ASC → Sorts in ascending order (default).
DESC → Sorts in descending order.

Demo Database

Below is a selection from the "Students" table in the school_db database:

student_id	name	gender	city	age	score	course_id	email	phone_number
1	Alice	Female	Delhi	20	85	101	NULL	1234567890
2	Bob	Male	Mumbai	22	75	NULL	bob@email.com	NULL
3	Charlie	Male	Delhi	21	95	102	NULL	NULL
4	David	Male	Bangalore	23	65	101	david@email.com	NULL
5	Eve	Female	Mumbai	20	80	103	NULL	NULL
6	Frank	Male	Delhi	22	90	103	NULL	NULL
7	Alice	Female	Mumbai	19	60	102	NULL	NULL

Sorting in Ascending Order (Default)

Example

SELECT * FROM students ORDER BY age;

Try it yourself

Retrieves all students sorted by age (smallest to largest).

Sorting in Descending Order

Example

SELECT * FROM students ORDER BY age DESC;

Try it yourself

Retrieves all students sorted by age (largest to smallest).

Sorting by Multiple Columns

Example

SELECT * FROM students ORDER BY age ASC, name DESC;

Try it yourself

Sorts students by age in ascending order, and if two students have the same age, they are sorted by name in descending order.

❮ Previous

Next ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.