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 informix sql?

975

What is cursor explain with example?

984

What are different types of statements supported by sql?

1165

Why do we use view in sql?

949

How many tables can a sql database have?

977

What language is oracle sql developer?

1010

What does a pl/sql package consist of?

973

Explain dml and ddl?

989

explain the difference between bool, tinyint and bit. : Sql dba

995

what is the difference between a having clause and a where clause? : Sql dba

1087

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

958

How many types of triggers exist in pl/sql?

1068

Why do we create views in sql?

1149

What is pl/sql language case sensitive?

1119

What do you think about pl/sql?

1029