#############在这段查询语句中 如何加上总计？###############

[LWWL]

select 厂名,
合计=sum(轧废+冷条+折叠+短尺+公差+拉丝+结疤+耳子+弯曲+凹坑+凸块+翘皮+其它),
轧废=sum(轧废),
冷条=sum(冷条),
折叠=sum(折叠),
短尺=sum(短尺),
公差=sum(公差),
拉丝=sum(拉丝),
结疤=sum(结疤),
耳子=sum(耳子),
弯曲=sum(弯曲),
凹坑=sum(凹坑),
凸块=sum(凸块),
翘皮=sum(翘皮),
其它=sum(其它)
from(
select 厂名='中型厂',轧废=z轧废,冷条=z冷条,折叠=z折叠,短尺=0,公差=z公差,拉丝=z拉丝,结疤=z结疤,耳子=z耳子,弯曲=z弯曲,凹坑=z凹坑,凸块=0,翘皮=0,其它=z其它 from pdate
union all
select 厂名='线材厂',轧废=x轧废,冷条=x冷条,折叠=x折叠,短尺=0,公差=x公差,拉丝=0,结疤=0,耳子=x耳子,弯曲=0,凹坑=0,凸块=x凸块,翘皮=x翘皮,其它=x其它 from pdate
union all
select 厂名='恒兴厂',轧废=h轧废,冷条=0,折叠=h折叠,短尺=h短尺,公差=0,拉丝=0,结疤=0,耳子=h耳子,弯曲=h弯曲,凹坑=0,凸块=0,翘皮=0,其它=h其它 from pdate
)a group by 厂名 order by 厂名 desc
GO

我想在最后一条加上总计

[zjcxc]

select 厂名=case grouping(厂名) when 1 then '总计' else 厂名 end,
合计=sum(轧废+冷条+折叠+短尺+公差+拉丝+结疤+耳子+弯曲+凹坑+凸块+翘皮+其它),
轧废=sum(轧废),
冷条=sum(冷条),
折叠=sum(折叠),
短尺=sum(短尺),
公差=sum(公差),
拉丝=sum(拉丝),
结疤=sum(结疤),
耳子=sum(耳子),
弯曲=sum(弯曲),
凹坑=sum(凹坑),
凸块=sum(凸块),
翘皮=sum(翘皮),
其它=sum(其它)
from(
select 厂名='中型厂',轧废=z轧废,冷条=z冷条,折叠=z折叠,短尺=0,公差=z公差,拉丝=z拉丝,结疤=z结疤,耳子=z耳子,弯曲=z弯曲,凹坑=z凹坑,凸块=0,翘皮=0,其它=z其它 from pdate
union all
select 厂名='线材厂',轧废=x轧废,冷条=x冷条,折叠=x折叠,短尺=0,公差=x公差,拉丝=0,结疤=0,耳子=x耳子,弯曲=0,凹坑=0,凸块=x凸块,翘皮=x翘皮,其它=x其它 from pdate
union all
select 厂名='恒兴厂',轧废=h轧废,冷条=0,折叠=h折叠,短尺=h短尺,公差=0,拉丝=0,结疤=0,耳子=h耳子,弯曲=h弯曲,凹坑=0,凸块=0,翘皮=0,其它=h其它 from pdate
)a group by 厂名 with rollup
order by grouping(厂名),厂名 desc

[子陌红尘]

select
厂名 = isnull(厂名,'总计'),
合计=sum(轧废+冷条+折叠+短尺+公差+拉丝+结疤+耳子+弯曲+凹坑+凸块+翘皮+其它),
轧废=sum(轧废),
冷条=sum(冷条),
折叠=sum(折叠),
短尺=sum(短尺),
公差=sum(公差),
拉丝=sum(拉丝),
结疤=sum(结疤),
耳子=sum(耳子),
弯曲=sum(弯曲),
凹坑=sum(凹坑),
凸块=sum(凸块),
翘皮=sum(翘皮),
其它=sum(其它)
from(
select 厂名='中型厂',轧废=z轧废,冷条=z冷条,折叠=z折叠,短尺=0,公差=z公差,拉丝=z拉丝,结疤=z结疤,耳子=z耳子,弯曲=z弯曲,凹坑=z凹坑,凸块=0,翘皮=0,其它=z其它 from pdate
union all
select 厂名='线材厂',轧废=x轧废,冷条=x冷条,折叠=x折叠,短尺=0,公差=x公差,拉丝=0,结疤=0,耳子=x耳子,弯曲=0,凹坑=0,凸块=x凸块,翘皮=x翘皮,其它=x其它 from pdate
union all
select 厂名='恒兴厂',轧废=h轧废,冷条=0,折叠=h折叠,短尺=h短尺,公差=0,拉丝=0,结疤=0,耳子=h耳子,弯曲=h弯曲,凹坑=0,凸块=0,翘皮=0,其它=h其它 from pdate
)a
group by
厂名 with rollup --加上with rollup
order by
厂名 desc
GO

[LWWL]

大家平分吧

[pingfzp]

good good !
WITH ROLLUP WITH CUBE 好东西