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 is difference between sql and mysql?

1194

Can we insert data in view?

1009

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1058

Explain what is a column in a table?

1157

Why plvtab is considered as the easiest way to access the pl/sql table?

1292

What are the disadvantages of file system?

1359

What is user defined functions?

1028

What is the purpose of normalization?

1086

Explain the uses of a database trigger?

1086

What is sap sql?

1030

Why is %isopen always false for an implicit cursor?

1151

What are different clauses used in sql?

1174

What are the different types of database management systems?

1036

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1092

What is schema in sql?

998