ORDER BY

Sort rows by a column with ORDER BY.

With ORDER BY you sort rows by a column. The default direction is ascending; use DESC for descending.

SELECT name, price
FROM products
ORDER BY price;

This sorts products by price in ascending order.

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

ORDER BY — details

ORDER BY comes after WHERE and before LIMIT. If you give multiple columns it sorts by the first, then by the second for ties.

For example, ORDER BY city, name sorts cities alphabetically and then sorts customers within the same city by name.

Select name and price from products ordered by price.

Show example solution

SELECT name, price
FROM products
ORDER BY price

Sorting

SELECT name FROM products
ORDER ____ price;

Show answer

SELECT name FROM products
ORDER BY price;

Next lesson: ASC and DESC