Complete Guide to SQL LIMIT and OFFSET Clauses
на канале: Fratello Innotech
SQL - LIMIT and OFFSET
Definition
The LIMIT and OFFSET clauses in SQL are used to control the number of records returned by a query. They are commonly used for pagination, displaying a specific number of rows, or retrieving records from a particular position in the result set.
SQL - LIMIT Clause
Definition
The LIMIT clause is used to restrict the number of rows returned by a query.
Example
SELECT * FROM employees
LIMIT 5;
Explanation
This query returns only the first 5 records from the employees table.
SQL - OFFSET Clause
Definition
The OFFSET clause is used to skip a specified number of rows before starting to return records.
Example
SELECT * FROM employees
LIMIT 5 OFFSET 10;
Explanation
This query skips the first 10 records and then returns the next 5 records.