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 reindexing?

1611

How to use "startup" command to start default instance?

963

How to drop an existing view in oracle?

905

How to use "if" statements on multiple conditions?

1113

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

2259

What is a snapshot in oracle database?

974

How to create a single index for multiple columns?

980

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1999

How to convert dates to characters in oracle?

987

How to use like conditions in oracle?

996

Is postgres faster than oracle?

972

why dont we assign not null constraint as table level constraint.

2685

6. Display the client name and order date for all orders using the traditional method.

2242

What is BBED in Oracle?

1091

What happens to the data files if a tablespace is dropped?

996