sum.txt

小计、汇总语法

--计算小计、汇总的SQL语法
select djh,sl from VIEW_xhmx where VIEW_xhmx.khdm='9001' and VIEW_xhmx.kdrq between '2006-01-01' and '2006-03-30' 
union
select djh+ ' 小 计',sum(sl)from VIEW_xhmx where VIEW_xhmx.khdm='9001' and VIEW_xhmx.kdrq between '2006-01-01' and '2006-03-30' 
group by djh
union
select '总计',sum(sl)from VIEW_xhmx where VIEW_xhmx.khdm='9001' and VIEW_xhmx.kdrq between '2006-01-01' and '2006-03-30'