关于MS SQL SERVER 的分组统计 100分相送,不够可以再加 分开写不行吗?写两条sql语句 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select bh,mc,sl,dj,je from abc group by bh,mc,sl,djunion all select '合计' as bh,null as mc,null as sl,null as dj,sum(je) as je from abc select * from abcunion allselect null,null,null,null,sum(je) from abc select bh,mc,sl,dj,je from abc group by bh,mc,sl,djunion all select null as bh,null as mc,null as sl,null as dj,sum(je) as je from abc select b.bh,a.mc,a.sl,a.dj,b.je from(select bh,sum(je) je from abc group by bh with rollup) bleft outer join abc a on a.bh = b.bh 这个或许可以:select * from abc compute sum(je) union all即可实现将两个查询合并到一个set中,所以这样子就可以了啊! 用compute sum(je)不行的 不能显示在一起 视图运用场景 紧急救援-SQL Server2005安装错误 这个更新语句该怎么写? SQL多表查询时,一个表的列值为另外一个表的表名,如何关联查询? 不能连接局域网的SQL服务器? 接分接错了,补分 不明白为什么Select * 和Select ×××,×××会有这么大区别呢? sql server agent 为何不能运行? 一個top問題? bcp 的用法? 关于表的自动生成!! 查询得好慢哦! 如何能快点呢?
union all
select '合计' as bh,null as mc,null as sl,null as dj,sum(je) as je from abc
union all
select null,null,null,null,sum(je) from abc
union all
select null as bh,null as mc,null as sl,null as dj,sum(je) as je from abc
(select bh,sum(je) je from abc group by bh with rollup) b
left outer join abc a on a.bh = b.bh