SELECT EARNMONTH, AREA, SUM(PERSONINCOME)
FROM EARNINGS
FROM EARNINGS
GROUP BY EARNMONTH,AREA;
SELECT EARNMONTH, AREA, SUM(PERSONINCOME)
FROM EARNINGS
GROUP BY ROLLUP(EARNMONTH,AREA);
注意的是ROLLUP()函数的使用,显示的样式问题!!!