select_agg_gs_sets.sql 121 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 grouping sets((x),(),(y))
  7. order by x,y