SELECT ename FROM emp WHERE NOT EXISTS (SELECT NULL

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 / nathan

Answer Posted / nathan

SELECT ename
FROM emp
WHERE NOT EXISTS (SELECT NULL
FROM dept
WHERE dept.deptno = emp.deptno);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What privilege is needed for a user to create indexes in oracle?

1007

What is a connect identifier?

1021

How to check database size in Oracle?

1168

How to create id with auto_increment on oracle?

966

Give the different types of rollback segments.

1015

Explain what are the advantages of views?

1048

How to write date and time interval literals in oracle?

1014

What is the max number of columns in an oracle table?

971

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2135

What do you mean by group by clause?

1020

How to define and use table alias names in oracle?

920

What is the scope of a local variable?

1043

How do I limit the number of oracle database connections generated by weblogic server?

1049

How does oracle handle read consistency?

1075

How to start your 10g xe server from command line?

1050