03 2013 档案

sql中ANY、SOME、ALL关键字
摘要：带any嵌套查询 select emp.empno,emp.ename,emp.sal from scott.emp where sal>any(select sal from scott.emp where job='manager'); 等价于 select sal from scott.emp where job='manager' 结果为 sal：2975 2850 245... 阅读全文
posted @ 2013-03-13 10:04 忙碌在路上 阅读(346) 评论(0) 推荐(0)
判断某结果集为空 执行另一个语句 case when 巧妙用法
摘要：SELECT case when not exists(SELECT Cons_Date FROM sbcHisMaster WHERE HisTypeNO='L' AND ProductSN ='M7D2028') THEN (SELECT Cons_Date FROM sbcHisMaster WHERE HisTypeNO='Y' AND ProductSN ='... 阅读全文
posted @ 2013-03-13 09:38 忙碌在路上 阅读(1046) 评论(0) 推荐(0)