Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 10 Answers
- 13503 Views
- Satyam, I also Faced
- E-Mail Answers
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
What is basic structure of pl sql?
Why is theta join required?
How to read/write files from pl/sql?
What are the different types of database management systems?
How many clustered indexes can you have?
What is lexical units in pl sql?
Why we use cross join?
What is oracle pl sql developer?
Why do we use procedures in sql?
What are the types of subqueries?
What is left join in postgresql?
What is bind reference and how can it be created?
Does sql require a server?
What will you get by the cursor attribute sql%found?
Why triggers are used?
