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

What is the minimum client footprint required to connect c# to an oracle database?

640

Oracle

1941

How to install oracle database 10g xe?

643

How to establish administrator authentication to the server?

626

How to grant create session privilege to a user in oracle?

649

How can we find out the duplicate values in an oracle table?

690

What are the attributes that are found in a cursor?

724

What is a dynamic performance view in oracle?

687

What is Library Cache in Oracle?

723

IS it possible to built the oracle database without setting the kernal parameters?

1849

Explain the features of oracle?

681

How to specify default values in insert statement using oracle?

671

can anyody please send me the dump for Oracle 10g certifications for DBA path?

1792

What is the difference between a primary key & a unique key?

674

List the types of joins used in writing subqueries?

658