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

What are the types of optimization?

889

Why do we use sql constraints? Which constraints we can use while creating database in sql?

973

What is the difference between function, procedure and package in pl/sql?

1138

What are the possible values that can be stored in a boolean data field?

949

What port does sql server use?

988

what are the join types in tsql? : Transact sql

983

Does sql require a server?

944

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

What is pl sql block in dbms?

952

what is “go” in t-sql? : Transact sql

1045

Does truncate release storage space?

1015

What is cross join example?

942

Which is faster count (*) or count 1?

968

What is sql server and ase?

978

Write a sql select query that only returns each name only once from a table?

962