Oracle8i也可以使用case 至少存储过程里可以使用动态SQL语句执行带有case有语句。select no,f1,f2,case when f1>f2 then true else false end f3 from table;
在oracle中可以用decode 在sqlserver中可以iif
SELECT ename, (CASE deptno WHEN 10 THEN 'ACCOUNTING' WHEN 20 THEN 'RESEARCH' WHEN 30 THEN 'SALES' WHEN 40 THEN 'OPERATIONS' ELSE 'Unassigned' END ) as Department FROM emp; 8i中可以用decode
select no,f1,f2,decode(sign(f1-f2),1,'true','false')f3 from table
谢了 再加分!
8i只能select no,f1,f2,decode(sign(f1-f2),1,true,false)f3 from table
至少存储过程里可以使用动态SQL语句执行带有case有语句。select no,f1,f2,case when f1>f2 then true else false end f3 from table;
在sqlserver中可以iif
(CASE deptno
WHEN 10 THEN 'ACCOUNTING'
WHEN 20 THEN 'RESEARCH'
WHEN 30 THEN 'SALES'
WHEN 40 THEN 'OPERATIONS'
ELSE 'Unassigned'
END ) as Department
FROM emp;
8i中可以用decode