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

what is offset-fetch filter in tsql? : Transact sql

949

What do you understand by exception handling in pl/sql?

1035

what is 'mysqlimport'? : Sql dba

1054

What does the hierarchical profiler does?

1058

What is a call statement? Explain with an example.

1010

What is sqlexception in java?

993

what is log shipping? : Sql dba

1118

what is commit? : Sql dba

1078

How to add new employee details in an employee_details table with the following details

1091

What is substitution variable in pl sql?

1045

Why do we create views in sql?

1154

How to prepare for oracle pl sql certification?

1066

What are basic techniques of indexing?

1384

Is sql considered coding?

1048

What are all different types of collation sensitivity?

1035