How do you delete duplicate records in sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to delete duplicate rows?

0 Answers  


i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,


What is the difference between truncate and delete commands?

0 Answers  


Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  


What is the function of inner join?

0 Answers  






difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,


how to take backup bcp out for a column in table in sql server?

0 Answers  


What does dml stand for?

0 Answers  


Define right outer join in sql server joins?

0 Answers  


Explain raiserror in sql server?

0 Answers  


Why do you need a sql server?

0 Answers  


what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  


Categories