yql/essentials/tests/sql/suites/insert/yql-14538.sql


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

use plato;

INSERT INTO Output
SELECT
    key as key,
    "" as subkey,
    "value:" || value as value
FROM Input
WHERE key < "100"
ORDER BY key
LIMIT 5;

INSERT INTO Output
SELECT
    *
FROM Input
ORDER BY key
LIMIT 4;