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出现问题了。求指教怎么修改
db2出现 SQLCODE=-440, SQLSTATE=42884, DRIVER=4.12.55
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
悬赏问题
- ¥15 chaquopy python 安卓
- ¥50 Kubernetes&Fission&Eleasticsearch
- ¥15 有没有帮写代码做实验仿真的
- ¥15 報錯:Person is not mapped,如何解決?
- ¥30 vmware exsi重置后登不上
- ¥15 易盾点选的cb参数怎么解啊
- ¥15 MATLAB运行显示错误,如何解决?
- ¥15 c++头文件不能识别CDialog
- ¥15 Excel发现不可读取的内容
- ¥15 关于#stm32#的问题:CANOpen的PDO同步传输问题