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

What are sql functions? Describe in brief different types of sql functions?

480

What is trigger and how to use it in sql?

529

Does truncate require commit?

537

how many groups of data types? : Sql dba

559

Does sql support programming?

545

What is a trigger word?

508

what are the differences between binary and varbinary? : Sql dba

527

Is sql easier than java?

518

Can we create table in function?

560

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

577

Are views faster than queries?

534

how can you create an empty table from an existing table? : Sql dba

652

explain the difference between myisam static and myisam dynamic. : Sql dba

509

What are types of joins?

529

Is sql difficult?

738