Learn › SQL Tutorial › Sorting with ORDER BY

Sorting with ORDER BY

1 min read

ORDER BY

Sort your results ascending (ASC, default) or descending (DESC).

SELECT name, price FROM products
ORDER BY price DESC;

You can sort by multiple columns:

SELECT * FROM products
ORDER BY category ASC, price DESC;