SELECT
CASE node_addr
WHEN '[email protected]' then '1'
when '[email protected]' then '3'
when '[email protected]' then '4'
else '5'
end
from CSC_TRAFFIC_DAY_10_8_2004这个在存储过程中怎么写呢?〉
CASE node_addr
WHEN '[email protected]' then '1'
when '[email protected]' then '3'
when '[email protected]' then '4'
else '5'
end
from CSC_TRAFFIC_DAY_10_8_2004这个在存储过程中怎么写呢?〉
oracle存储过程中,编译以下代码时:
SELECT
SUM(CASE WHEN KT_KHXX.K_NXQZL<5 THEN 1 ELSE 0 END ) 小于5,
SUM(CASE WHEN KT_KHXX.K_NXQZL>5 and KT_KHXX.K_NXQZL < 10 THEN 1 ELSE 0 END ) 5-10,
SUM(CASE WHEN KT_KHXX.K_NXQZL>10 and KT_KHXX.K_NXQZL < 15 THEN 1 ELSE 0 END ) 10-15 ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>15 and KT_KHXX.K_NXQZL < 20 THEN 1 ELSE 0 END ) 15-20 ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>20 and KT_KHXX.K_NXQZL < 25 THEN 1 ELSE 0 END ) 20-25 ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>25 THEN 1 ELSE 0 END ) 大于25
into n1,n2,n3,n4,n5,n6
FROM KT_KHXX;提示错误:未找到预期from关键字!这是怎么回事?语法应该没错吧?
SUM(CASE WHEN KT_KHXX.K_NXQZL<5 THEN 1 ELSE 0 END ) "小于5",
SUM(CASE WHEN KT_KHXX.K_NXQZL>5 and KT_KHXX.K_NXQZL < 10 THEN 1 ELSE 0 END ) "5-10",
SUM(CASE WHEN KT_KHXX.K_NXQZL>10 and KT_KHXX.K_NXQZL < 15 THEN 1 ELSE 0 END ) "10-15" ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>15 and KT_KHXX.K_NXQZL < 20 THEN 1 ELSE 0 END ) "15-20" ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>20 and KT_KHXX.K_NXQZL < 25 THEN 1 ELSE 0 END ) "20-25" ,
SUM(CASE WHEN KT_KHXX.K_NXQZL>25 THEN 1 ELSE 0 END ) "大于25"
into n1,n2,n3,n4,n5,n6
FROM KT_KHXX;字段不允许有非法字符,用双引号引起来就可以