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

how to join query for one source type is oracle another source type is sql server ?

2476

List out the types of joins.

1235

What are the different types of partitions in oracle?

1029

What's dateware house and what's clustor with practicle example

2231

Explain oracle 12c new features for developers?

1119

What are the benefits of ordbms?

1136

Can we connect to ORACLE db using Windows Authentication?

1304

What is set verify off in oracle?

1153

What is pragma autonomous transaction in oracle?

1121

What is a database table in oracle?

1067

How can windows applications connect to oracle servers?

1115

Why does for update in oracle 8 cause an ora-01002 error?

1043

How to get a create statement for an existing table?

1010

How to name query output columns in oracle?

1237

What are a cluster and non-cluster index?

1064