表 div
字段
divNo,divName,mcount,rcount
分组查询
select divNo,sum(mcount) from div group by divNo,divName
1 20
2 10
3 10
4 10
想要得到这些组的合计信息
可以这样写
select decode(grouping_id,'3','合计',divNo) divNoItem,sum(mcount) from div group by rollup((divNo,divName))
1 20
2 10
3 10
4 10
合计 50
如果这样写
select decode(grouping_id,'3','合计',divNo) divNoItem,sum(mcount) from div group by rollup(divNo,divName) ,少个括号
结果又不一样了。 :D
字段
divNo,divName,mcount,rcount
分组查询
select divNo,sum(mcount) from div group by divNo,divName
1 20
2 10
3 10
4 10
想要得到这些组的合计信息
可以这样写
select decode(grouping_id,'3','合计',divNo) divNoItem,sum(mcount) from div group by rollup((divNo,divName))
1 20
2 10
3 10
4 10
合计 50
如果这样写
select decode(grouping_id,'3','合计',divNo) divNoItem,sum(mcount) from div group by rollup(divNo,divName) ,少个括号
结果又不一样了。 :D