if 3 duplicate records in a table,i want to delete 2 duplicate
records by keeping 1 duplicate and 1 original as it is,how?

Answer Posted / arun ashok

STEP 1 : Insert distinct value in the one new table.
STEP 2 : Delete the values from existing table.
STEP 3 : Again insert the values from new table to existing
table.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to insert stored procedure result into temporary table?

827


How to create dbo table in sql server?

758


Where are full-text indexes stored?

776


Tell me about builtinadministrator?

777


What is store procedure? How do they work? When do you use?

746


Are semicolons required at the end of sql statements in sql server 2005?

786


What is scalar user-defined function?

773


What are the differences between char and varchar in ms sql server?

817


Explain about merge replications?

808


Does group by or order by come first?

760


Explain about system database?

844


What is the difference between a "where" clause and a "having" clause?

895


Is ssrs support other database except ms sql server?

108


How we can compare two database data?

729


What is a system database and what is a user database?

824