Home Explore Help
Sign In
SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git
1
0
Fork 0
Files
Tree: 686cf76645
Branches Tags
ydb
/
yql
/
essentials
/
tests
/
sql
/
suites
/
pg
/
select_win_cume_dist.sql

select_win_cume_dist.sql 143 B
History Raw

123 
  1. --!syntax_pg
    2. 

  2. SELECT cume_dist() over w FROM (VALUES (4),(5),(5),(6)) as a(x)
    3. 

  3. window w as (ORDER BY x ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)
    4.