MySQL — Order By

Basic ORDER BY

-- Ascending order (default)
SELECT * FROM users ORDER BY name ASC;

-- Descending order
SELECT * FROM users ORDER BY name DESC;

ORDER BY Multiple Columns

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

ORDER BY Examples

-- Sort by date
SELECT * FROM orders
ORDER BY created_at DESC;

-- Sort by multiple columns
SELECT * FROM products
ORDER BY category ASC, price DESC;

-- Sort by expression
SELECT name, price * stock AS value
FROM products
ORDER BY value DESC;

-- Sort with LIMIT
SELECT * FROM products
ORDER BY price DESC
LIMIT 10;

ORDER BY with Functions

-- Sort by string length
SELECT * FROM users
ORDER BY LENGTH(name) DESC;

-- Sort by date part
SELECT * FROM users
ORDER BY MONTH(created_at), DAY(created_at);

Mini Practice

Write MySQL code that:

1. Sorts by name ascending
2. Sorts by date descending
3. Sorts by multiple columns
4. Combines with LIMIT

Up Next

Next: Learn about Grouping Data.