selecet empno,ename from table a minus select empno,ename from table 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 / raj kumar

Answer Posted / raj kumar

selecet empno,ename from table a
minus
select empno,ename from table b

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many times can we commit in a loop?

1067

What are character functions?

1141

How many types of primary keys are there?

1079

Why is sharding used?

1060

Can you do multiple joins in sql?

1120

How can a pl sql block be executed?

1004

What's the difference between inner join and left join?

1041

What is the largest value that can be stored in a byte data field?

1060

What is difference between nchar and nvarchar?

1101

What is relationship? How many types of relationship are there?

1262

What is before and after trigger?

1010

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1302

How do you select unique values in sql?

1047

define sql update statement ? : Sql dba

1159

What is hibernate and its relation to sql?

1171