select_win_cume_dist.sql « pg « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/pg/select_win_cume_dist.sql

blob: 315f428496291d295481db9a6be8b0cc8218a941 (plain) (blame)

1
2
3

--!syntax_pg
SELECT cume_dist() over w FROM (VALUES (4),(5),(5),(6)) as a(x)
window w as (ORDER BY x ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)