you should be able to use the:
1、ROLLUP operation to produce subtotal values
2、CUBE operation to produce cross-tabulation values
3、GROUPING function to identify the row values created by ROLLUP or CUBE
4、GROUPING SETS to produce a single result set
原文：http://blog.51cto.com/3938853/2159858
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！