yql/essentials/tests/sql/suites/window/full/noncompact_with_tablerow.sql


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

/* syntax version 1 */
/* postgres can not */

SELECT
    key,
    subkey,
    value,

    AGGREGATE_LIST(TableRow()) OVER w AS frame,

FROM plato.Input
WINDOW
    w as (PARTITION BY key, subkey ORDER BY value ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
ORDER BY value;