SQL 技巧-ORACLE
摘要:
1)在select语句中使用条件逻辑 1select ename,sal, 2 case when sal = 4000 then 'OVERPAID' 4 else 'OK' 5 end as status 6from emp ENAME SAL STATUS ---------- ---------- -------... 阅读全文
posted @ 2009-04-28 19:05 dolphin_bobo 阅读(274) 评论(0) 推荐(0) 编辑