blob: 45e5bd1866e049d3f99164bbe5bb553e06ee466a (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
# LIMIT and OFFSET
`LIMIT`: limits the output to the specified number of rows. By default, the output is not restricted.
`OFFSET`: specifies the offset from the beginning (in rows). By default, it's zero.
## Examples
```yql
SELECT key FROM my_table
LIMIT 7;
```
```yql
SELECT key FROM my_table
LIMIT 7 OFFSET 3;
```
```yql
SELECT key FROM my_table
LIMIT 3, 7; -- equivalent to the previous example
```
|
