select * from A except select * from B

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 / shrawan kumar keshri

Answer Posted / shrawan kumar keshri

select * from A
except
select * from B

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is use of package in pl sql?

1013

What is the use of index in hive?

1007

explain advantages of innodb over myisam. : Sql dba

1128

What is sql and db2?

1003

What are data types in pl sql?

1141

How do you use join?

940

What are all the common sql functions?

1025

What does trigger mean in slang?

1052

What sql does db2 use?

979

What are the types of variable use in pl sql?

1080

what are set operators in sql? : Sql dba

1052

what is data integrity? : Sql dba

1036

What is optimistic concurrency control? : Transact sql

982

how are mysql timestamps seen to a user? : Sql dba

1139

How many triggers can be applied to a table?

1063