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

In what condition is it good to disable a trigger?

1014

What is the difference among union, minus and intersect?

1003

How does an execution block start and end in pl sql?

955

How do you select unique values in sql?

1003

Why are cursors used?

1123

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1237

What is $$ in sql?

997

Explain the significance of the & and && operators in pl sql.

1009

What is row_number () in sql?

986

What does truncate mean in sql?

1031

What are sql procedures?

1030

What do you mean by stored procedures?

1015

What are expressions?

1018

What is a constraint? Tell me about its various levels.

1164

Explain polymorphism in pl/sql.

1124