SELECT DISTINCT A.stockcode AS stockcode,
B.VHCMODEL AS VHCMODEL,
count (A.stockcode) AS STOCKCODESUM,
sum (decode (A.STATUS,
'3',
1,
0))
AS FACHEJIHUAYINGXIANGTAISHU,
sum (decode (A.STATUS,
'2',
1,
0))
AS DIAOBOYINGXIANGTAISHU,
sum (decode (A.STATUS,
'1',
1,
0))
AS DANGRIJIHUATAISHU,
sum (decode (A.STATUS,
'0',
1,
0))
AS WEIWANCHENGTAISHU,
case when decode (count (A.stockcode),
0,
0.00,
decode(
sum (decode (A.STATUS,
'1',
1,
0)))) >= 1
then
round (decode (count (A.stockcode),
0,
0.00,
decode(
sum (decode (A.STATUS,
'1',
1)))
/ ( count (A.stockcode)
- sum (decode (A.STATUS,
'3',
1,
0))
- sum (decode (A.STATUS,
'2',
1,
0))),
4))
* 100
when decode (count (A.stockcode),
0,
0.00,
decode(
sum (decode (A.STATUS,
'1',
1,
0)))) = 0
then 0.00
end
AS DANGRIJIHUAWANCHENGLV
FROM VHC_WASHTASK_TB A, VHC_LEDJER_TB B
WHERE PLAN_NO = '20161115' AND A.VINNO = B.VINNO
GROUP BY A.stockcode, B.VHCMODEL
ORDER BY A.STOCKCODE
这个是我的sql，在最后一个列中decode出现问题了。求指教怎么修改