LIMIT Clause in SQLite

SQLite LIMIT Clause
To limit the number of records fetched from a table, the SQLite LIMIT clause is used with the SELECT command.

Syntax 1:

SELECT column1, column2, column_N   
FROM table_name  
LIMIT [no of rows]   

Syntax 2: Using Offset

SELECT column1, column2, column_N   
FROM table_name  
LIMIT [no of rows] OFFSET [row num]   

Example 1:
TEACHERS Table:

SELECT * FROM TEACHERS 
LIMIT 2;

Output:

Explanation:
In the above example, we are fetching records of the first two rows of the TEACHERS table.

Example2:
TEACHERS Table:

SELECT * FROM TEACHERS  LIMIT 2 OFFSET 2;

Output:

Explanation:
In the above example, we are fetching records of two rows of the TEACHERS table, starting from the third position (after the offset value which is 2).