SELECT LIMIT is used to limit the rows displaying from the result-set based on the specified limit value in statement. SELECT LIMIT does not support all SQL Databases. SELECT LIMIT works only on MySQL.

SELECT column1, column2, …, columnN
FROM table_name
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
[LIMIT number_of_rows [OFFSET offset_value]]; 

• column1, column2, …, columnN – Specifies the columns to be displayed in output.
• number_of_rows – Specifies how many rows displayed from the first row.
• offset_value – Specifies how many rows should skip from the first row.

consider employee_details table are as follows -

Scenario – Fetch first three rows using SELECT LIMIT.

Requirement - Fetch all details of first 3 employees from employee_details table. The query was as follows -

SELECT * FROM employee_details LIMIT 3; 

By executing above query, we can get results as shown below -

Scenario – Fetch first two rows.

Requirement1– Fetch first two employees who got highest salaries from employee_details table. The query was as follows –

SELECT * FROM employee_details ORDER BY salary DESC LIMIT 2; 

By executing above query, we can get results as shown below –

Requirement2 - Fetch first two employees who got lowest salaries from employee_details table. The query was as follows –

 SELECT * FROM employee_details ORDER BY salary ASC LIMIT 2; 

By executing above query, we can get results as shown below –

Scenario – Fetch p rows, by skipping q rows from total n rows.

Requirement – Fetch 2nd and 3rd rows belongs to department 1000 from employee_details. The query was as follows -

SELECT * FROM employee_details 
WHERE dept_id = 1000 LIMIT 2 OFFSET 1; 

By executing above query, we can get results as shown below –