select_agg_gs_grouping.sql 143 B

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