Use of SQL Limit
Author: Al-mamun Sarkar
Date: 2020-04-14 18:26:50
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;