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

yi 8677

Book 2401

19479

NULL 70787