关于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)不行的 不能显示在一起 ms-sql top where和 变量的问题 急求一SQL语句,在线等候!!! 模糊搜索多个关键字时,CHARINDEX 与like哪个效率更好? SQL两表的联合查询-----在线等!! 求空列位置 关于sql数据库文件*.mdf和*.log大小的一些疑问 请问这条语句错在那里? 今天太黑了啊~ 关于mssql快照复制的问题...拜托高手帮帮我!!! 怎样动态生成查询语句的问题 关于表的自动生成!! 查询得好慢哦! 如何能快点呢?
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