SELECT job, sal,
DECODE(job, 'ANALYST', SAL*1.1,
'CLERK', SAL*1.15,
'MANAGER', SAL*1.20,
SAL)
REVISED_SALARY
FROM emp;
DECODE(job, 'ANALYST', SAL*1.1,
'CLERK', SAL*1.15,
'MANAGER', SAL*1.20,
SAL)
REVISED_SALARY
FROM emp;
调试欢乐多
我的意思是table_column的值为不确定的数值,只要大于0 就为1,否则为0
decode(sign(table_column),1,1,0)
SELECT "ZZJG_RY"."DWBM",
CASE WHEN to_number( substr( "ZGXX"."WHCD",1,1) )>=7 THEN '6' ELSE substr( "ZGXX"."WHCD",1,1) END
FROM "ZGXX",
"ZZJG_RY"
when x>0 then sign(x) = 1
when x=0 then sign(x) = 0
when x<0 then sign(x) = -1
case con
when 'A' then a1;return 1;
when 'B' then a2;return 2;
when 'C' then a3;return 3;
end as aa;
加几个括号就行了.