94

SQLite LIMIT Clause

The SQLite LIMIT clause is used to limit the data amount fetched by SELECT command from a table.

Syntax:

The LIMIT clause can also be used along with OFFSET clause.

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.

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.

Output:

---