Source: https://dev-docs.yueshu.com.cn/v5.3.2/database-gql-reference/dql/clauses/limit/
Documentation version: v5.3.2

# 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 |
+-----+--------------+

````