SELECT e2.Empno, e2.Ename FROM B e2 WHERE e2.Empno NOT IN

TABLE A TABLE B
EMPNO ENAME EMPNO ENAME
1 A 1 A
2 B 2 B
3 C 3 C
4 D 4 D
5 E 5 E
6 F
7 G
HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

Question Posted / swastik

Answer Posted / swastik

SELECT
e2.Empno, e2.Ename
FROM B e2
WHERE e2.Empno NOT IN
(
SELECT e1.Empno
FROM A e1
);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which are sql * plus commands?

1109

how to do backup entire database? : Transact sql

1112

Can we call procedure in select statement?

1039

What is pl sql package?

1022

How to load data with sql*loader?

1034

Can we use update in sql function?

1046

What is sql catalog?

1000

What is mutating table error?

1158

What is the reports view in oracle sql developer?

958

Is pl sql useful?

967

What is a pl/sql block?

1199

Where not exists in sql?

965

Can we have two clustered index on a table?

1011

How to Execute a Package in PL/SQL.?

1185

What is a sql instance vs database?

1101