yql/essentials/tests/sql/suites/pg/select_win_count.sql


1
2
3
4
5
6
7
8

--!syntax_pg
select x,y,count(x) over w 
from (values (1,2),(null::int4,3),(2,4),(2,5)) as a(x,y)
window w as ();

select x,y,count(x) over w 
from (values (1,2),(null::int4,3),(2,4),(2,5)) as a(x,y)
window w as (order by y);