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

Which is better Oracle or MS SQL? Why?

6302

What are operators in oracle?

1026

What is blob data type in oracle?

1063

Write a trigger example in oracle?

1001

What are advantages of dateset in datastage?

2221

Calculate difference between 2 date / times in oracle sql?

1009

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2306

How to call a stored function in oracle?

975

What is the use of aggregate functions in oracle?

991

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1036

How to export several tables together?

1008

What is oracle join syntax?

963

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4130

Explain what are the advantages of views?

1028

What is raw datatype in oracle?

1085