Summary - Ordering and limit

Combine ORDER BY, LIMIT and OFFSET to write a paged query.

In this group you learned ORDER BY, ASC/DESC, LIMIT and OFFSET. Combine them to write a paged sorted query.

SELECT name, price
FROM products
ORDER BY price DESC
LIMIT 5 OFFSET 0;

This returns the 5 most expensive products; first page.

name, price is selected from products. The result is sorted by price in descending order. 0 rows are skipped and the next 5 are returned.

Exercise Summary - Ordering and limit

Select the name and price of the 2 most expensive products.

Show example solution

SELECT name, price
FROM products
ORDER BY price DESC
LIMIT 2