yql/essentials/tests/sql/suites/window/win_func_auto_arg.sql


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

/* postgres can not */
/* syntax version 1 */
USE plato;
PRAGMA DisableAnsiRankForNullableKeys;

SELECT
    RANK() over w as rank_noarg,
    DENSE_RANK() over w as dense_rank_noarg,
    RANK(cast(subkey as uint32) / 10 % 2) over w as rank,
    DENSE_RANK(cast(subkey as uint32) / 10 % 2) over w as dense_rank,
    zz.*
FROM
    Input4 as zz
WINDOW
    w as (PARTITION BY key ORDER BY subkey)
ORDER BY key, subkey, value
;