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

What does select top 1 do in sql?

1007

Explain what is sql?

1061

what's the difference between a primary key and a unique key? : Sql dba

973

What is the use of nvl function?

1128

Explain the purpose of %type and %rowtype data types?

876

Whis is not false in primary key?

1406

Does user triggers have entry for trigger with compilation errors?

975

What are the packages in pl sql?

968

Can a commit statement be executed as part of a trigger?

998

How do I save a stored procedure?

951

what is auto increment? : Sql dba

965

Are stored procedures compiled?

873

Which is faster subquery or join?

1148

How do I remove all records from a table?

1026

What is replication id?

886