select g.工序 as 车间,sum(g.单日产量) as [产量(KG)],
case g.工序 when N'搅拌' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('A1','A2','C2','C3'))
when N'热压' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('C4','C5','D1','D2','D3','D4','D6','M'))
when N'内外磨' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('F','G1','G2','H'))
end as [废次品(KG)]
from gxu g
group by g.工序我想问下怎么样实现[产量(KG)],[废次品(KG)]这两列的总和,根据上面的语句,再用一条sql代码显示出来
case g.工序 when N'搅拌' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('A1','A2','C2','C3'))
when N'热压' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('C4','C5','D1','D2','D3','D4','D6','M'))
when N'内外磨' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('F','G1','G2','H'))
end as [废次品(KG)]
from gxu g
group by g.工序我想问下怎么样实现[产量(KG)],[废次品(KG)]这两列的总和,根据上面的语句,再用一条sql代码显示出来
解决方案 »
- C# Winform Mdi子窗口标题和MenuStrip的MdiWindowListItem菜单同步问题
- 请问编写一个webserver有没有什么调试方法或者工具?
- C# 如何动态调用dll中全局事件
- 如何发布WINFORM项目 带ACCESS数据库
- 求助:关于SQL 多表查询
- 【求助】C#写CGI的问题!
- 用户提出要做一个批量制作条码标签的程序,请大虾给点提示(100分)
- 多线程中使用集合出错,高手请进
- C#中绘图的问题
- ■■■怎样做个三角形的Button?
- 想把一段java程序改为c#的 不知道this("hello");怎么修改 有没有能帮我把程序重写成c#的.......
- 一个sql问题 希望大家 帮忙解决 先谢过了(急)在线== 这个问题很郁闷
case g.工序 when N'搅拌' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('A1','A2','C2','C3'))
when N'热压' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('C4','C5','D1','D2','D3','D4','D6','M'))
when N'内外磨' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('F','G1','G2','H'))
end as [废次品(KG)]
from gxu g
group by g.工序) b
case g.工序 when N'搅拌' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('A1','A2','C2','C3'))
when N'热压' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('C4','C5','D1','D2','D3','D4','D6','M'))
when N'内外磨' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('F','G1','G2','H'))
end as [废次品(KG)],[产量(KG)]+ [废次品(KG)] as [总和]
from gxu g
group by g.工序
from (
select g.工序 as 车间,sum(g.单日产量) as [产量(KG)],
case g.工序 when N'搅拌' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('A1','A2','C2','C3'))
when N'热压' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('C4','C5','D1','D2','D3','D4','D6','M'))
when N'内外磨' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('F','G1','G2','H'))
end as [废次品(KG)]
from gxu g
group by g.工序)tb
select sum(g.单日产量) as [产量(KG)],
case g.工序 when N'搅拌' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('A1','A2','C2','C3'))
when N'热压' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('C4','C5','D1','D2','D3','D4','D6','M'))
when N'内外磨' then (select sum(f.废品*f.单重) from 废次品 f where f.废次品代码 in('F','G1','G2','H'))
end as [废次品(KG)]
from gxu g