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
巨人網(wǎng)絡通訊聲明:本文標題《Sql Server 分組統(tǒng)計并合計總數(shù)及WITH ROLLUP應用》,本文關鍵詞 Sql,Server,分組,統(tǒng)計,并,合計,;如發(fā)現(xiàn)本文內容存在版權問題,煩請?zhí)峁┫嚓P信息告之我們,我們將及時溝通與處理。本站內容系統(tǒng)采集于網(wǎng)絡,涉及言論、版權與本站無關。
相關文章
下面列出與本文章《Sql Server 分組統(tǒng)計并合計總數(shù)及WITH ROLLUP應用》相關的同類信息!