WITH ROLLUP 在生成包含小计和合计的报表时，ROLLUP 运算符很有用。ROLLUP 运算符生成的结果集类似于 CUBE 运算符所生成的结果集。
SELECT [Source], COUNT(*) AS OrderTotal FROM [ExternalOrder] Where OrderStatus=1 AND (CheckPayment=1 ) and TicketDate >= '2012-11-1' AND TicketDate < '2012-12-1' GROUP BY [Source] WITH ROLLUP Order by [Source] desc
结果集：
Source OrderTotal ZongHengV2 215 ZongHeng 3889 YixingSky 3919 YiSkyV2 901 Wanggou 1034 Uni800 1151 TaoBao 3876 ShanglvPT 897 Shanglvbao 426 Qunar 9878 PiaoMeng 429 KuXun 1549 JinRi 2661 HangTuo 140 HangLvTong 7 EasyGo 501 Aooxing 5458 AirPP 3299 8000yi 8677 51Book 2401 517 19479 NULL 70787