chear

摘要： WITHROLLUP 在生成包含小计和合计的报表时，ROLLUP 运算符很有用。ROLLUP 运算符生成的结果集类似于 CUBE 运算符所生成的结果集。SELECT[Source],COUNT(*)ASOrderTotalFROM[ExternalOrder]WhereOrderStatus=1AND(CheckPayment=1)andTicketDate>='2012-11-1'ANDTicketDate<'2012-12-1'GROUPBY[Source]WITHROLLUPOrderby[Source]desc结果集：Source Order 阅读全文