select [PI],Model,Line, sum(Pass) as Pass,sum(Fail) as Fail, sum(Pass+Fail) as hj,
ltrim(cast(sum(Fail)/sum(Pass+Fail)*100 as decimal(18,2)))+'%' '坏机率' from [MesCount]
GROUP BY [PI],Model,Line
为什么最后一列总是为0%,当其分子有小数点时,就是想要的结果。
ltrim(cast(sum(Fail)/sum(Pass+Fail)*100 as decimal(18,2)))+'%' '坏机率' from [MesCount]
GROUP BY [PI],Model,Line
为什么最后一列总是为0%,当其分子有小数点时,就是想要的结果。
这样写
select [PI],Model,Line, sum(Pass) as Pass,sum(Fail) as Fail, sum(Pass+Fail) as hj,
ltrim(cast(cast(sum(Fail) as decimal(18,2))/cast(sum(Pass+Fail)*100 as decimal(18,2)) as decimal(18,2)))+'%' '坏机率' from [MesCount]
GROUP BY [PI],Model,Line