软件开发工程师试题(含答案)软件开发工程师试题1、试分析下面的SQL语句的优劣，并用另外的方法实现。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)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 likesmith%;select count(*),sum(sal) from emp where dept_no = 0030 and ename likesmith%;select count(decode(dept_no,0020,x,null) d0020_count,count(decode(dept_no,0030,x,
