select e.ename from e where e.eid in ( (select e.eid from e minus se

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 / sudipta santra

Answer Posted / sudipta santra

select e.ename from e where e.eid in (
(select e.eid from e
minus
select eid from empdept,d where d.did=empdept.did))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to Truncate Table in Oracle

1156

How to create a temporary table in oracle?

1270

How translate command is different from replace?

1088

State some uses of redo log files?

1010

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

how to do daily transactions with out sql* loader control file regesterd in apps?

1687

How to connect to a remote server?

1127

Explain joins in oracle?

1037

What is procedure overloading in oracle?

1061

Will you be able to store pictures in the database?explain.

992

What is a connect identifier?

1039

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

2161

Oracle

2377

State and explain the different types of data models?

944

How to check the server version in oracle?

1092