oracle部面试题.docVIP

面试题一（厦门） Table: （员工emp1） id name 1 a 2 b 3 c 4 d Table: 性别 sext id sex 1 男 4 女 5 男 找出忘记填写性别的员工（用 Oracle 的两种方式） select id ,name from emp1 e where e.id not in select id from sext ; select id from emp1 minus select id from sext; select * from emp1 e where e.id all select id from sext ; select e.* from emp1 e, select id from emp1 minus select id from sext s where e.id s.id; select e.id,e.name from emp1 e,sext s where e.id s.id + and s.sex is null; select * from emp1 left outer join sext on emp1.id sext.id where sext.sex is null; select * from emp1 e where not exists select * from se