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

How can we avoid duplicating records in a query?

558

What is cursor status?

759

Explain scalar functions in sql?

575

How do I run a script in sql developer?

485

What is offset in sql query?

589

Is pl sql different from sql?

526

What are the basic sql commands?

543

what is a foreign key ? : Sql dba

601

Why we use stored procedure instead of query?

527

What are secondary keys?

555

explain commit and rollback in mysql : sql dba

538

What is microsoft t sql?

488

what are the advantages and disadvantages of views in a database? : Sql dba

526

What is information schema in sql?

572

How can we optimize a sql query?

570