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

Why sql query is slow?

928

explain the delete statements in sql

973

Why stored procedures are faster than query?

968

What is lexical units in pl sql?

1041

when is the use of update_statistics command? : Sql dba

966

What are character functions in sql?

891

Can pl sql procedure have a return statement?

956

Explain exception handling in pl/sql?

987

Explain the advantages and disadvantages of stored procedure?

1075

Does execute immediate commit?

1147

Why should I use postgresql?

966

What is sqlcommand?

962

How to install oracle sql developer?

981

Why do we use sqlite?

909

How do I view a sql trace file?

960