一套软件开发工程师笔试题.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. No2、用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_salfrom