SQLite Limit Clause

by Online Tutorials Library July 14, 2022

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.

  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:

Sqlite Limit clause 1

Example1:

Fetch the records from the “STUDENT” table by using LIMIT according to your need of number of rows.

Output:

Sqlite Limit clause 2

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:

Sqlite Limit clause 3

Next TopicSQLite Order By Clause

SQLite Limit Clause

SQLite LIMIT Clause

SUM Function in SQL

Event Listener

You may also like