select_win_expr_lead.sql 135 B

1234567
  1. --!syntax_pg
  2. select lead(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