blob: 9a6dd2300f9a3155ae364766f523ad3a18280ae1 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
$input = SELECT * FROM AS_TABLE([
<|k: 1, v: 1|>,
<|k: 2, v: 2|>,
<|k: 3, v: 3|>,
<|k: 4, v: 4|>,
<|k: 5, v: 5|>,
]);
SELECT * FROM $input ORDER BY k LIMIT NULL OFFSET CAST(3 AS Uint64);
SELECT * FROM $input ORDER BY k LIMIT NULL OFFSET CAST((SELECT 3) AS Uint64);
SELECT * FROM $input ORDER BY k LIMIT NULL OFFSET CAST((SELECT Avg(v) FROM $input) AS Uint64);
SELECT * FROM $input ORDER BY k LIMIT NULL OFFSET CAST((SELECT Avg(v) FROM $input WHERE v == 3) AS Uint64);
|
