体验新版 GitCode,发现更多精彩内容 >>
-- @author tungs1 -- @modified 2013-07-28 12:00:00 -- @created 2013-07-28 12:00:00 -- @description groupingfunction groupingfunc62.sql -- @db_name groupingfunction -- @executemode normal -- @tags groupingfunction -- order 1 SELECT GROUPING(product.pname) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1,g2; g1 | g2 ----+------ 0 | 200 0 | 300 0 | 400 0 | 700 0 | 800 0 | 800 0 | 1600 1 | 200 1 | 200 1 | 300 1 | 300 1 | 400 1 | 400 1 | 600 1 | 600 1 | 700 1 | 700 1 | 800 1 | 800 1 | 800 1 | 800 1 | 1000 1 | 1000 (23 rows)