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?
Answer Posted / damy
select * from b where b.empno not in(select a.empno from a);
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to order siblings in oracle hierarchy queries?
Define the select into statement.
What is difference between pls_integer and integer?
How do you bind variables in pl sql?
what are the types of join and explain each? : Sql dba
What is db journal file?
Difference between global and parameter variables?
What is primary key secondary key alternate key candidate key?
What is sql lookup?
Enlist the characteristics of pl/sql?
What is scalar function in sql?
What is package in pl sql with an examples?
What are procedures used for?
What is offset and limit in sql?
what is 'trigger' in sql? : Sql dba