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
- 6827 Views
- I also Faced
- E-Mail Answers
Answer Posted / debi
(select * from table2)
minus
(select * from table1)
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
How do you test your database? : sql server database administration
What is user-defined inline table-valued function?
When I run the sql server 2000 setup, it just hangs. What do I do?
What is the dbcc command and why is it used?
What are the kinds of subquery?
What are the benefits of filtered indexes?
What are orphan records?
Write a code to select distinct records without using the DISTINCT keyword.
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Do you know what is lock escalation?
What is full outer join in sql server joins?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is the purpose of the tempdb database?
What are sql servers used for?
How the authentication mode can be changed?
