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 do you know if a relationship is 2nf?

877

Why is pl sql used?

936

how to do backup entire database? : Transact sql

1067

how to shutdown mysql server? : Sql dba

1027

How much does a sql dba make? : SQL DBA

888

How do you rank data in sql?

935

What is lookup table in sql?

979

What is bulk compiling in pl/sql.?

1060

Why do we need pl sql?

934

what is top in tsql? : Transact sql

1022

Is sql scripting language?

973

what are aggregate and scalar functions? : Sql dba

992

what is meant by nl2br()? : Sql dba

973

What are records give examples?

953

what is the difference between a web-garden and a web-farm? : Sql dba

1009