LIMIT Clause

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 3^rd position.

SELECT * FROM STUDENT LIMIT 3 OFFSET 2;   

Output: