select_win_expr_agg.sql 134 B

1234567
  1. --!syntax_pg
  2. select sum(x+1 + sum(z)) over w as l from (
  3. values (1,2,3),(1,5,3)) a(x,y,z)
  4. group by x+1,y
  5. window w as (
  6. )
  7. order by l