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
- 7101 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
Why use update_statistics command in sql server?
What is coalesce and check constraint in sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
how to overcome kernel isssues
How the authentication mode can be changed?
What command do we use to rename a database?
What is model database in sql server?
What are the disadvantages of using querystrings to send data from one page to another?
What are the dis_advantages of stored procedures, triggers, indexes?
Do I need a report server to run reports in my application?
What is service broker?
What is the difference between a unique key and primary key?
What is optimistic concurrency?
Explain what is lock escalation?
How to use copy and concatenate commands in SQL?
