OFFSET
8min
This article describes using the OFFSET clause to skip a specified number of rows.
Overview
The OFFSET is a clause that skips some records from the result set.
Syntax
The basic syntax of the OFFSET clause is shown below:
Syntax
|
The parameters and arguments from the syntax are:
- columns: the columns to be fetched.
- table_name: a table from which the records will be fetched.
- OFFSET: a clause that will skip a subset of records.
- num: the number of records to be skipped.
Example
1) Here, we are creating one new table called oxlafunctions using the CREATE TABLE command and inserting some values into the table using the INSERT command:
Create a table
|
2) To verify that the values have been inserted successfully, retrieve the result set using the command below:
Display the table
|
Output
|
3) Use the LIMIT clause in conjunction with the OFFSET clause to skip a subset of records:
Select query
|
In the above query:
- The “LIMIT 5” clause is used to fetch only five records.
- The “OFFSET 2” clause is used to skip the first two records before retrieving the result set of the limit clause.
4) You will get the following output:
Output
|

Updated 11 May 2023
Did this page help you?
Yes
No