Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8052 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 specific conditions database should meet, before you can bulk copy data into it using bcp?
What is the difference between Normalization and De-normalization?
can an order by clause be used in a creation of a view?
What is a benefit of using an after insert trigger over using a before insert trigger?
Is sql server difficult to learn?
What is resource db in sql server?
How much memory that we are using in Logshipping Concept?
How many triggers you can have on a table?
What is difference between views and tables?
Can group by be used without aggregate functions?
What are key constraints?
What language is sql server written in?
When would you use sql joins?
what is the system function to get the current user's user id? : Sql server database administration
Can primary key be null?
