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 many types of triggers exist in pl/sql?

1053

Why stored procedures are faster than query?

1008

What do you mean by field in sql?

1071

What is the use of non clustered index?

979

what is clause? : Sql dba

1054

what are the drivers in mysql? : Sql dba

1006

what is isam? : Sql dba

990

What is substitution variable in pl sql?

1029

What kind of join is join?

949

What is cursor and its types?

1050

what are rollup and cube in t-sql? : Transact sql

1074

How do you modify a trigger?

915

Define union, minus, union all, intersect ?

988

What does sign mean sql?

1077

What is sql injection owasp?

1042