group by：
select WhCode, BillType, SUM(currQuantity) Qty from bcStockRecord
group by WhCode, BillType
select WhCode, BillType, SUM(currQuantity) Qty from bcStockRecord
group by WhCode, BillType with rollup
select WhCode, BillType, SUM(currQuantity) Qty from bcStockRecord
group by WhCode, BillType with cube
select WhCode,GROUPING(WhCode), BillType,GROUPING(BillType), SUM(currQuantity) Qty from bcStockRecord
group by WhCode, BillType with cube
扫一扫
440
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
