-- @author tungs1
-- @modified 2013-07-28 12:00:00
-- @created 2013-07-28 12:00:00
-- @description groupingfunction groupingfunc97.sql
-- @db_name groupingfunction
-- @executemode normal
-- @tags groupingfunction
-- order 1
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  200 |  1
  300 |  0
  300 |  1
  400 |  0
  400 |  1
  600 |  1
  700 |  0
  700 |  1
  800 |  0
  800 |  0
  800 |  1
  800 |  1
 1000 |  1
 1600 |  0
(15 rows)