LIMIT

Limit the number of rows returned.

With LIMIT you cap the number of rows returned. The most common use is fetching the top or bottom N records.

SELECT name, price
FROM products
ORDER BY price DESC
LIMIT 3;

This returns the 3 most expensive products. LIMIT comes after ORDER BY.

name, price is selected from products. The result is sorted by price in descending order. Only the first 3 rows are returned.

LIMIT — details

LIMIT is usually paired with ORDER BY; otherwise which rows come back is undefined. To get any 5 rows from a table you write LIMIT 5.

For the 3 best-selling products you write ORDER BY sales DESC LIMIT 3; without sorting, "the first 3" has no meaning.

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

Show example solution

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

Top 3 records

SELECT name FROM products
ORDER BY price DESC
____;

Show answer

SELECT name FROM products
ORDER BY price DESC
LIMIT 3;

Next lesson: OFFSET