There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did

There are three tables :
E : EID,ENAME
D : DID,DNAME
empdept : eid, did

select the employees who doesn't belong to any dep

Question Posted / testingcareer.kpc

Answers were Sorted based on User's Feedback

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees..

Answer / neha_gupta

SELECT E.ENAME FROM EMPLOYEE E WHERE E.EID IN (SELECT EID
FROM EMPDEPT WHERE DID IS NULL)

Is This Answer Correct ?

5 Yes

1 No

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees..

Answer / sudipta santra

select e.ename from e where e.eid in (
(select e.eid from e
minus
select eid from empdept,d where d.did=empdept.did))

Is This Answer Correct ?

1 Yes

0 No

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees..

Answer / nathan

SELECT ename
FROM emp
WHERE NOT EXISTS (SELECT NULL
FROM dept
WHERE dept.deptno = emp.deptno);

Is This Answer Correct ?

0 Yes

0 No

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees..

Answer / ajit

select e.eid, e.ename
from E e, D d
where e.eid = d.did(+)
and d.did is null;

Is This Answer Correct ?

0 Yes

0 No