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