hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
- 4 Answers
- 7425 Views
- I also Faced
- E-Mail Answers
Answer Posted / gangadhar
select * from table2 where id not in ( select id from
table1)
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What is the synonym of join?
What is sql service broker?
What is single-user mode?
How global temporary tables are represented and its scope?
Why use triggers?
Explain log shipping and mention its advantages.
What are the different types of sub-queries?
Define cursor locking
What does it mean to normalize a database and why would you do it?
List out some of the requirements to set up a sql server failover cluster?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
whats the maximum size of view state??
How to provide default values to stored procedure parameters?
What is standby servers? Explain types of standby servers.
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
