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
- 8045 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu sudhan g
Hiii
Its very simple to get the records that doesn't match lets
table1 is No1 and having A column values 1,2,3,4,5 and Table2
is No2 having column B values 1,2,3,4,5,6,7,8,9,10
Now Query is
select B from NO2 where B NOT IN(select A from NO1)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
How to concatenate two binary strings together?
How to test a dml trigger in ms sql server?
How does Report Builder support Analysis Services cubes?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Who developed sql server?
What is the difference between osql and query analyzer?
What are the different methods available under sqlcommand class to access the data?
What are the properties of the transactions?
Explain relational data?
What are system databases into sql server (2005/2008)?
How do I create a trace in sql server?
What is blocking and how would you troubleshoot it? : sql server database administration
How to drop an existing user defined function in ms sql server?
How many types of triggers in sql server?
