-- @author tungs1-- @modified 2013-07-28 12:00:00-- @created 2013-07-28 12:00:00-- @description groupingfunction groupingfunc173.sql-- @db_name groupingfunction-- @executemode normal-- @tags groupingfunction-- order 1select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT sale.pn FROM sale)) as a; ?column? | g1 ----------+----- a | 200 a | 300 a | 100 a | 500 a | 700 a | 0 a | 1 a | 400 a | 600 a | 800(10 rows)