Sqlite 简明教程
SQLite - LIMIT Clause
SQLite LIMIT 子句用于限制 SELECT 语句返回的数据量。
SQLite LIMIT clause is used to limit the data amount returned by the SELECT statement.
Syntax
以下是带 LIMIT 子句的 SELECT 语句的基本语法。
Following is the basic syntax of SELECT statement with LIMIT clause.
SELECT column1, column2, columnN
FROM table_name
LIMIT [no of rows]
以下是 LIMIT 子句与 OFFSET 子句一起使用时的语法。
Following is the syntax of LIMIT clause when it is used along with OFFSET clause.
SELECT column1, column2, columnN
FROM table_name
LIMIT [no of rows] OFFSET [row num]
如最后一个示例所示,SQLite 引擎将返回从下一行开始到给定 OFFSET 的行。
SQLite engine will return rows starting from the next row to the given OFFSET as shown below in the last example.
Example
考虑具有以下记录的 COMPANY 表 -
Consider COMPANY table with 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
以下是一个限制表中行数的示例,根据您想要从表中获取的行数。
Following is an example, which limits the row in the table according to the number of rows you want to fetch from table.
sqlite> SELECT * FROM COMPANY LIMIT 6;
这将产生以下结果。
This will produce the following result.
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
然而在某些情况下,您可能需要从某个特定的偏移量中挑选一组记录。这是一个示例,它从第 3 个位置开始挑选 3 条记录。
However in certain situations, you may need to pick up a set of records from a particular offset. Here is an example, which picks up 3 records starting from the 3rd position.
sqlite> SELECT * FROM COMPANY LIMIT 3 OFFSET 2;
这将产生以下结果。
This will produce the following result.
ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0