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

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1915

What are the differences between interval year to month and interval day to second?

1030

How to resolve the ORA-39133 error in Oracle?

1126

How to calculate date and time differences in oracle?

1045

When do I need to use a semicolon vs a slash in oracle sql?

1090

Explain a private synonyms?

1043

How to connect to the server with user account: sys?

1024

What is a read write transaction in oracle?

1094

How to define a sub function?

1138

what is normalisation?what are its uses?

2278

Does facebook use oracle?

1038

Query to retrieve record for a many to many relationship ?

2522

How oracle handles dead locks?

1071

How to update values in a table in oracle?

1027

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

2161