MySQL LIMIT Clause

The LIMIT clause is used to specify the number of records to return.

The LIMIT clause is useful on large tables with thousands of records. Returning a large number of records can impact performance.

SELECT column_name(s)
FROM table_name
WHERE condition
LIMIT number;

You can also use OFFSET to skip a number of records before starting to return the records.

SELECT * FROM Customers LIMIT 10 OFFSET 15;

This is often used for pagination.

Example

SELECT * FROM Customers LIMIT 3;