ASC and DESC

Learn ascending and descending ordering.

ASC sorts ascending, DESC descending. After ORDER BY you write the column name then the direction.

SELECT name, price
FROM products
ORDER BY price DESC;

This sorts products by price descending; the most expensive on top.

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

ASC and DESC — details

ASC is the default so omitting it still sorts ascending. For text ASC means alphabetical, for numbers smallest first. DESC is the reverse.

To see the most expensive products at the top, you write ORDER BY price DESC.

Select name and price from products ordered by price descending.

Show example solution

SELECT name, price
FROM products
ORDER BY price DESC

Sort descending

SELECT name FROM products
ORDER BY price ____;

Show answer

SELECT name FROM products
ORDER BY price DESC;