Use of SQL Limit

Use of SQL Limit. The following command shows how to use LIMT on SQL Query.

 

SQL LIMIT Syntax:

SELECT column, column, ...
FROM table_name
WHERE condition
LIMIT number;

Example: 

SELECT * FROM employees
LIMIT 3;

 

Adding Offset:

SELECT * FROM employees
LIMIT 4, 3;