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
- 7100 Views
- I also Faced
- E-Mail Answers
Answer Posted / newbie
SELECT * from Table2
EXCEPT
SELECT * FROM Table1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are security principals used in sql server 2005?
Give an example of why you would want to denormalize a database
What is Federation Root Database?
What are the differences between union, intersect, and minus operators?
What is the difference between ddl and dml?
How to attach adventureworkslt physical files to the server?
How do I make a resultset scrollable?
What is the partitioning method?
How to call stored procedure using http soap?
What are the benefits of filtered indexes?
What is the new security features added in sql server 2016? : sql server security
What is bit data type? What's the information that can be stored inside a bit column?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
how would you troubleshoot blocking? : Sql server database administration
How to add more data to the testing table in ms sql server?
