MYSQL LIMIT clause is used to restrict the number of rows returned by a SELECT query.

Syntex:

SELECT column1, column2, ... FROM table_name LIMIT number_of_rows;

Additionally, you can use an optional OFFSET clause to specify the starting point (offset) from where the result set should begin. 

SELECT column1, column2, ... FROM table_name LIMIT number_of_rows OFFSET offset_value;

Example:

SELECT * FROM employees LIMIT 5;


SELECT * FROM employees LIMIT 5 OFFSET 5;