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


1
2
3
4
5
6
7
8

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

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