Limiting results with LIMIT
• The LIMIT clause in SQL allows users to control the amount of data retrieved and displayed in the result set.
SELECT column1, column2, . . .
FROM table_name
WHERE condition
ORDER BY column
LIMIT [offset.] row_count;
EXAMPLE:
SELECT * FROM users
WHERE age > 30
ORDER BY age
LIMIT 5;