yql/essentials/tests/sql/suites/window/win_func_with_group_by.sqlx


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

/* postgres can not */
USE plato;

--INSERT INTO Output
SELECT
    RANK(), -- unable to use window function with GROUP BY
    key
FROM
    Input as zz
GROUP BY
    key
;