Multi-column ordering

Sort by multiple columns.

To sort by multiple columns you separate them with commas. It sorts by the first, then by the second for ties.

SELECT name, category, price
FROM products
ORDER BY category, price DESC;

It sorts by category ascending, then by price descending within each category.

name, category, price is selected from products. The result is sorted by category, price in descending order.

Multi-column ordering — details

You can give each column its own direction. ORDER BY category ASC, price DESC is valid. A secondary column breaks ties.

For example, to list products in each category starting from the cheapest, you write ORDER BY category, price ASC.

Select name, category and price from products ordered by category then price descending.

Show example solution

SELECT name, category, price
FROM products
ORDER BY category, price DESC

Two-column sort

SELECT name FROM products
ORDER BY category, ____;

Show answer

SELECT name FROM products
ORDER BY category, price;

Next lesson: LIMIT