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

10 Answers
13245 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / b

select * from B
minus
select * from A;

Is This Answer Correct ?

12 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what is a view?

997

What is primary key secondary key alternate key candidate key?

980

what is schema? : Sql dba

986

Which nosql database is best?

924

How to write html code in pl sql?

1055

How can get second highest salary in sql?

909

Which type of cursor is used to execute the dml statement?

894

What are the different types of constraints?

1072

Is sql an operating system?

961

How do you define a foreign key?

938

What is the difference between sql and t sql?

964

What is the difference between a procedure and a function?

1011

What is dense_rank in sql?

916

What are dml commands?

939

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

954