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

Is sql better than excel?

1126

Explain locks? : Transact sql

989

What are different types of tables in sql?

985

describe transaction-safe table types in mysql : sql dba

993

Where is all the data on the internet stored?

993

how are mysql timestamps seen to a user? : Sql dba

1119

What is the difference between an inner join and an outer join?

1007

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1041

What are the types of join in sql?

1085

what is myisam? : Sql dba

1060

What do you mean by query optimization?

991

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1048

Which is better varchar or nvarchar?

982

what is a trigger in mysql? : Sql dba

1134

Which version of sql do I have?

1039