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?
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 |
Post New Answer View All Answers
How do you know if a relationship is 2nf?
Why is pl sql used?
how to do backup entire database? : Transact sql
how to shutdown mysql server? : Sql dba
How much does a sql dba make? : SQL DBA
How do you rank data in sql?
What is lookup table in sql?
What is bulk compiling in pl/sql.?
Why do we need pl sql?
what is top in tsql? : Transact sql
Is sql scripting language?
what are aggregate and scalar functions? : Sql dba
what is meant by nl2br()? : Sql dba
What are records give examples?
what is the difference between a web-garden and a web-farm? : Sql dba