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 are the attributes of cursor?

1104

Explain the blob datatype?

1122

What is translate in oracle?

1140

How will you write a query to get a 5th rank student from a table student_report?

1918

How can we create the complete backup of data in the oracle.

2199

How to retrieve values from data fields in record variables?

1171

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1788

What is bulk copy or bcp in oracle?

1182

What is a database schema in oracle?

1150

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2342

Explain alias?

1193

Difference between cartesian join and cross join?

1093

What do database buffers contain?

1081

What is a nvl function?

1093

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2421