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
- 11630 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 posting?
what is sp_pkeys? : Transact sql
what is a constraint? Tell me about its various levels. : Sql dba
How do I access sql anywhere database?
What is meant by user defined function?
What is mdf ldf and ndf?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
what are all the different types of indexes? : Sql dba
What is sql procedures and functions?
What are the two characteristics of a primary key?
Which is better trigger or stored procedure?
What is the best sql course?
What is null in pl/sql?
Does inner join return duplicate rows?
What is the most restrictive isolation level? : Transact sql
