select * from B minus select * from A;

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

Answer Posted / b

select * from B
minus
select * from A;

Is This Answer Correct ?

12 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Which software is used for pl sql programming?

1034

what is a relationship and what are they? : Sql dba

1165

What is lexical units in pl sql?

1206

What is composite data type in pl sql?

1168

what are date and time functions in mysql? : Sql dba

1022

What is meaning of <> in sql?

1129

Can a table contain multiple foreign key’s?

1050

How to display Row Number with Records in Oracle SQL Plus?

1094

What is java sql driver?

1182

What is a sql instance vs database?

1170

How many clustered indexes can you have?

1037

what is self-join? : Sql dba

1239

What is an example of translating a date into julian format?

1201

What is benefit of creating memory optimized table?

1032

What are the different sql commands?

1126