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

Explain two easy sql optimizations.

994

What are the types of optimization?

927

How many aggregate functions are available there in sql?

965

how do you know the version of your mysql server? : Sql dba

986

how to use in conditions? : Sql dba

992

How many types of relationship are there?

1016

what tools available for managing mysql server? : Sql dba

1062

What is the basic structure of an sql?

1076

Can we join tables without foreign key?

944

What are different types of tables in sql?

976

Does execute immediate commit?

1195

Define implicit and explicit cursors.

1125

What is audit logout in sql profiler?

1005

What is auto increment in sql?

1096

What is type and rowtype in pl sql?

1007