面试注意点.docVIP

面试注意点 1、试分析下面的SQL语句的优劣，并用另外的方法实现。 (1) Select * from empe where e.No in (select a. No from amp a ) Select * from empe e where NOT EXISTS (Select a.No from amp a where e.NO=a.No) (2) select * from emp e, anp a where e. No=a. No 2、用Decoole 重写下面的socl 语句 SELECT COUNT(*)，SUM(SAL) FROM EMP WHERE DEPT_NO = 0020 AND ENAME LIKE　‘SMITH%’; select count(*),sum(sal) from emp where dept_no = 0030 and ename like　‘smith%’; select count(decode(dept_no,0020,’x,null)) d0020_count, count(decode(dept_no,0030,’x,null)) d0030_count, sum(decode(dept_no,0020,sal,0)) d0020_sal, sum(decode(dept_no,0030,sal,0)) d0030_sal