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 cte sql?

513

What is Difference Between Unique and Primary Key Constraints?

602

How do you declare a user-defined exception?

523

What are the different dml commands in sql?

584

what is sub-query? : Transact sql

591

What is meant by temporal data?

536

What are database links used for?

591

What are the qualities of 2nf?

540

What is view explain with example?

514

Can we create table inside stored procedure?

530

How do I clear the screen in sql plus?

544

Is like operator in sql case sensitive?

504

What are the advantages of stored procedure?

535

What are data types in pl sql?

552

What are few of the schema objects that are created using PL/SQL?

555