SQLite’s LIMIT Clause is used to restrict the value of the With The following is The SQLite engine will return from the next line until the given Hypothetical Here is an example that limits the number of rows you want to extract from the table: This will produce the following results: However, in some cases, you may need to extract the record from a specific offset. The following is an example of extracting three records from the third bit: This will produce the following results:
SELECT
The amount of data returned by the statement. 1.22.1. Grammar ¶
LIMIT
Of the clause
SELECT
The basic syntax of the statement is as follows:SELECT column1, column2, columnN
FROM table_name
LIMIT [no of rows]
LIMIT
Clause vs.
OFFSET
Syntax when using clauses together:SELECT column1, column2, columnN
FROM table_name
LIMIT [no of rows] OFFSET [row num]
OFFSET
All lines up to now, as shown in the last example below. 1.22.2. Example ¶
COMPANY
The table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
sqlite> SELECT * FROM COMPANY LIMIT 6;
ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
sqlite> SELECT * FROM COMPANY LIMIT 3 OFFSET 2;
ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0