The SQLite LIMIT clause is used to limit the data amount fetched by SELECT command from a table.
Syntax:
SELECT column1, column2, columnN FROM table_name LIMIT [no of rows]
The LIMIT clause can also be used along with OFFSET clause.
SELECT column1, column2, columnN FROM table_name LIMIT [no of rows] OFFSET [row num]
Example:
Let's take an example to demonstrate SQLite LIMIT clause. We have a table named 'STUDENT' having following data:
Example1:
Fetch the records from the "STUDENT" table by using LIMIT according to your need of number of rows.
SELECT * FROM STUDENT LIMIT 5;
Output:
Example2:
OFFSET is used to not retrieve the offset records from the table. It is used in some cases where we have to retrieve the records starting from a certain point:
Select 3 records form table "STUDENT" starting from 3rd position.
SELECT * FROM STUDENT LIMIT 3 OFFSET 2;
Output:
