select_agg_gs_rollup.sql 107 B

1234567
  1. --!syntax_pg
  2. select x,y
  3. from (
  4. values (1,2),(1,2),(2,3),(2,2)
  5. ) a(x,y)
  6. group by rollup(x,y)
  7. order by x,y