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 exception handling is done in advance pl/sql?

983

What is view explain with example?

936

What program will open a mdb file?

969

how to create a new view in mysql? : Sql dba

941

what is the use of double ampersand (&&) in sql queries?

1177

What are sql constraints?

1180

what is sql in mysql? : Sql dba

1199

What is rtm in testing?

1121

How to fix oracle error ora-00942: table or view does not exist

1017

what is denormalization. : Sql dba

1117

What are the most important ddl statements in sql?

1117

Which sorts rows in sql?

1024

What are the different types of tables in sql?

1009

what are the performance and scalability characteristics of mysql? : Sql dba

999

What is implicit cursor in pl sql?

1097