select * from b where b.empno not in(select a.empno from a);

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 / damy

Answer Posted / damy

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between joins?

1094

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1287

Can we alter stored procedure?

1042

What is pl sql record in oracle?

1088

Does sql view stored data?

1003

What are the ways on commenting in a pl/sql code?

1204

How to add a column ‘salary’ to a table employee_details?

1052

how to decrement dates by 1 in mysql? : Sql dba

1075

What is the use of & in pl sql?

1097

What is cost in sql execution plan?

1045

Mention what is the use of function "module procedure" in pl/sql?

1088

What is multiple partition?

1019

Can we use delete in merge statement?

1100

Why do we use cursors?

1043

Differentiate between sga and pga.

1206