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 a pl/sql block?

1199

How many joins in sql?

983

What is difference between function and trigger?

1024

What is on delete set null?

1071

Is the primary key an index?

1018

Is sql workbench free?

972

what is meant by nl2br()? : Sql dba

1011

What is an invalid partition table?

1011

Which version of sql do I have?

1036

Is there a way to automate sql execution from the command-line, batch job or shell script?

954

what is self-join? : Sql dba

1128

Why do we need unique key in a table?

942

How many sql databases can you have on one server?

1061

What is data control language (dcl)?

1114

What is the order of sql select?

1030