select * from a full outer join b on a.empno=b.empno minus select *

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 / baji

Answer Posted / baji

select * from a full outer join b on a.empno=b.empno
minus
select * from a inner join b on a. empno=b.empno;

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do rank () and dense_rank () differ?

514

Is pl sql different from sql?

526

What is an inner join sql?

540

How can you view the errors encountered in a trigger?

544

Differentiate pl/sql and sql?

557

What are the types of variables use in pl sql?

498

What is bind reference and how can it be created?

572

how to calculate the difference between two dates? : Sql dba

543

Are pl sql variables case sensitive?

590

How do we accept inputs from user during runtime?

540

What is nvarchar max in sql?

573

What is insert command in sql?

522

What is the difference between function, procedure and package in pl/sql?

556

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

529

Which sql statement is used to return only different values?

498