--查询处理
select 类别,
合计=sum(轧废+冷条+折叠+短尺+列编),
轧废=sum(轧废),
冷条=sum(冷条),
折叠=sum(折叠),
短尺=sum(短尺),
列编=sum(列编)
from(
select 类别='z',轧废=z轧废,冷条=z冷条,折叠=z折叠,短尺=0,列编=0 from tb
union all
select 类别='x',轧废=x轧废,冷条=0,折叠=0,短尺=x短尺,列编=0 from tb
union all
select 类别='h',轧废=0,冷条=h冷条,折叠=0,短尺=0,列编=h列编 from tb
)a group by 类别 order by 类别 desc
go