MySQL — Limit

Basic LIMIT

SELECT * FROM users LIMIT 10;

LIMIT with OFFSET

-- Skip first 5, return next 10
SELECT * FROM users LIMIT 10 OFFSET 5;

-- Alternative syntax
SELECT * FROM users LIMIT 5, 10;

LIMIT Examples

-- Get first 10 users
SELECT * FROM users
ORDER BY created_at DESC
LIMIT 10;

-- Pagination (page 2, 10 items per page)
SELECT * FROM users
ORDER BY id
LIMIT 10 OFFSET 10;

-- Get top 5 products by price
SELECT * FROM products
ORDER BY price DESC
LIMIT 5;

-- Random row
SELECT * FROM users
ORDER BY RAND()
LIMIT 1;

Pagination Example

-- Page 1
SELECT * FROM users ORDER BY id LIMIT 10 OFFSET 0;

-- Page 2
SELECT * FROM users ORDER BY id LIMIT 10 OFFSET 10;

-- Page 3
SELECT * FROM users ORDER BY id LIMIT 10 OFFSET 20;

Mini Practice

Write MySQL code that:

1. Limits results to 10 rows
2. Uses OFFSET for pagination
3. Gets top 5 records
4. Gets a random row

Up Next

Next: Learn about Sorting Data.