SELECT E.ENAME FROM EMPLOYEE E WHERE E.EID IN (SELECT EID FROM EMPDEPT WH

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 / neha_gupta

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to create lov dynamically at runtime & attach to text field?

1137

What suggestions do you have to reduce the network traffic?

939

Explain the difference between a procedure and a function? What do you understand by those terms?

1056

how to join query for one source type is oracle another source type is sql server ?

2406

how the indexes are stored in the Oracle Database?

2257

Please explain compound trigger in oracle?

1038

What is a snapshot log?

988

What is an oracle cursor variable?

1047

What is the maximum number of triggers that can be applied to a single table?

1003

Explain the use of indexes option in imp command.

1152

What do you mean by redo log file mirroring?

1009

What is object data modeling?

936

Can sub procedure/function be called recursively?

984

What are the differences between char and nchar in oracle?

1067

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1966