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
- 8171 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
How to create new tables with "select ... Into" statements in ms sql server?
What are the source of constraints?
Explain about system database?
List out a number of the wants to setup a SQL Server failover cluster?
What are filegroups in sql server?
How to create a view with data from multiple tables?
Find columns used in stored procedure?
What are cursors and when they are useful?
 Explain what is sql override for a source taLle in a mapping?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How extra digits are handled with numeric data type literals?
What stored by the model? : sql server database administration
what is a transaction and what are acid properties? : Sql server database administration
Explain how to use linked server?
How many columns can exist together per table?
