Basic Syntax

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

ORDER BY (Ascending – Default)

SELECT * 
FROM students
ORDER BY marks;

Explanation:
Students are sorted by marks from lowest to highest.

ORDER BY DESC (Descending)

SELECT * 
FROM students
ORDER BY marks DESC;

Explanation:
Students are sorted by marks from highest to lowest.

ORDER BY Multiple Columns

SELECT * 
FROM students
ORDER BY city ASC, marks DESC;

Explanation:
1. First sorted by city (A–Z)
2. Within each city, sorted by marks (high → low)

ORDER BY with Specific Columns

SELECT name, marks
FROM students
ORDER BY name ASC;

Explanation:
Displays only name and marks, sorted alphabetically.