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 are the different sql languages?

1023

explain the difference between delete , truncate and drop commands? : Sql dba

1074

What is string join?

963

Is stored procedure faster than query?

950

Why do we create stored procedures & functions in pl/sql and how are they different?

927

Explain the uses of a database trigger?

1017

What is user in sql?

1004

Define concurrency control. : Transact sql

1154

Advantages and disadvantages of stored procedure?

1103

Explain the order of sql statement execution?

1028

how to write date and time literals? : Sql dba

946

What is query execution plan in sql?

1168

How many types of indexes are there in sql?

973

Explain the purpose of %type and %rowtype data types with the example?

974

what is a primary key? : Sql dba

1026