yql/essentials/tests/sql/suites/select_yql/from_values_limit_offset.yql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

PRAGMA YqlSelect = 'force';

SELECT
    a,
FROM (
    VALUES
        (0),
        (1),
        (2),
        (3),
        (4),
        (5),
        (6)
) AS x (
    a
)
LIMIT 3 OFFSET 2;