LIMIT

Applies to: sql

LIMIT restricts how many rows a query returns, often paired with ORDER BY for top-N queries.

SELECT * FROM trades
ORDER BY price DESC
LIMIT 10;

See also: select, order-by, offset