LIMIT¶
LIMIT子句指定返回行数的上限。
语法¶
- limit_clause
limit_clause ::=
'LIMIT' number_of_rows
参数¶
number_of_rows¶
代表返回行数上限的非负整数。如果此上限大于或等于总行数，则返回所有行。否则，返回的记录数不超过此上限。
示例¶
上限小于总行数¶
'''
TABLE users TYPED TABLE {id INT, name STRING} =
(199, "Julie Kavner"),
(198, "Tom Cruise"),
(197, "Amy Hasegawa")
FOR r IN users
RETURN r.id AS id, r.name AS name
LIMIT 2
'''
上述语句限定只返回前 2 行。
返回：
+-----+--------------+
| id | name |
+-----+--------------+
| 199 | Julie Kavner |
| 198 | Tom Cruise |
+-----+--------------+
上限大于总行数¶
如果上限大于总行数，则返回所有行。
'''
TABLE users TYPED TABLE {id INT, name STRING} =
(199, "Julie Kavner"),
(198, "Tom Cruise"),
(197, "Amy Hasegawa")
FOR r IN users
RETURN r.id AS id, r.name AS name
LIMIT 100
'''
返回：
+-----+--------------+
| id | name |
+-----+--------------+
| 199 | Julie Kavner |
| 198 | Tom Cruise |
| 197 | Amy Hasegawa |
+-----+--------------+