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 are the types of subqueries?

1055

How to get unique records from a table?

971

Explain correlated query work?

1051

How do I save a sql query?

1012

Can we join more than 2 tables in sql?

1018

How do we accept inputs from user during runtime?

1062

Is truncate ddl or dml?

991

Does group by remove duplicates?

1039

Is it important to partition hard disk?

1024

tell us something about heap tables. : Sql dba

1098

What is coalesce in sql?

1057

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

What is triggering circuit?

1064

When is the update_statistics command used?

1116

describe mysql connection using mysql binary. : Sql dba

1066