select *from B where (empno,ename) not in (Select empno,ename 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 / arun

Answer Posted / arun

select *from B where (empno,ename) not in (Select
empno,ename from A)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

explain the difference between delete , truncate and drop commands? : Sql dba

1097

What is the use of triggers?

1039

How can we solve sql error: ora-00904: invalid identifier?

1249

What are the types of index in sql?

1071

Why use truncate instead of delete?

1018

Why trigger is used in sql?

976

what is a constraint? Tell me about its various levels. : Sql dba

989

Why stored procedure is faster than query?

1064

How to test for null values?

1056

Can we rollback after truncate?

1034

What does t sql mean?

951

Sql technical questions

1284

what is an extent ? : Sql dba

1105

How can we debug in PL/SQL?

1137

Should I use mbr or gpt?

1027