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 can the performance of a trigger be improved?

993

Which are the different types of indexes in sql?

993

What is the use of desc in sql?

916

What is difference between cursor and trigger?

1021

What is data manipulation language?

1137

What is a constraint?

963

What is the difference between syntax error and runtime error?

1069

What are the commands used in sql?

1017

What is sql comments?

1038

What is your daily office routine?

2220

What are sql commands?

938

What are tables and fields in the database?

1025

how would you enter characters as hex numbers? : Sql dba

939

How do you use a while loop in pl sql?

942

What are the indexing methods?

1003