select a,b,c,d from table1 union all select sum(a) as a,sum(b) as b,sum(c) as c,sum(d) as d from table1
select * from Table1union all select name+' Toal' name ,sum(num1),sum(num2) from Table1
where name not in('Lab','R&D')
group by name
--order by name
union all select 'R&D & Lab' name,sum(num1),sum(num2) from Table1
where name in('Lab','R&D')
union all select 'Total' name,sum(num1),sum(num2) from Table1
order by name
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)