select_win_expr_partition.sql 157 B

12345678
  1. --!syntax_pg
  2. select row_number() 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. partition by x+1 + sum(z)
  7. )
  8. order by l