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

What is coalesce in sql?

555

How to select random rows from a table?

518

Is record in pl sql?

513

what is the command line end user interface - mysql? : Sql dba

496

What is set serveroutput on?

637

What is full join?

524

Is sql harder than python?

602

How do you sort in sql?

594

Which data dictionary views have the information on the triggers that are available in the database?

750

How to run pl sql program in mysql?

509

What is the difference between clustered and non-clustered index in sql?

516

Explain normalization and what are the advantages of it?

514

what are properties of a transaction? : Sql dba

555

What is difference between inner join and self join?

586

What are the most important ddl statements in sql?

570