select_win_min.sql 204 B

12345678
  1. --!syntax_pg
  2. select x,y,min(x) over w
  3. from (values (1,2),(1,3),(2,4),(2,5)) as a(x,y)
  4. window w as ();
  5. select x,y,min(x) over w
  6. from (values (1,2),(1,3),(2,4),(2,5)) as a(x,y)
  7. window w as (order by y);