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

Mention what is the use of function "module procedure" in pl/sql?

689

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

595

Is postgresql a server?

648

i have some prob lem to tell me about my self in interview first round ...

1793

What are the different type of joins in sql?

625

Are there any features that are decommissioned in 11g that are not present in 11g?

1694

Does a primary key have to be a number?

604

who introduced sql?

656

What is cross join sql?

590

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

671

How does a trigger work?

627

What is rank () in sql?

617

How to set up sql*plus output format in oracle?

690

What is sql used for?

742

Why do we need unique key in a table?

600