select b.empno,b.ename from b where not exists(select * from a where a.emp

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

Answer Posted / bijaylaxmi

select b.empno,b.ename from b where not exists(select * from a
where a.empno=b.empno)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to get help at the sql prompt?

1162

What are operators available in sql?

1095

List the various privileges that a user can grant to another user?

1090

what is online transaction processing (oltp)? : Sql dba

1038

What do you mean by stored procedures?

1067

What are the different types of constraints?

1273

Does db2 use sql?

1009

What is t-sql? : Transact sql

1039

how to shut down the server with 'mysqladmin'? : Sql dba

1049

What is compilation error in pl sql?

1023

what is foreign key? : Sql dba

1105

What is right join in sql?

1152

what is the difference between join and union? : Sql dba

1195

Why do we create stored procedures & functions in pl/sql and how are they different?

991

Why is a trigger used?

990