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?
- 5 Answers
- 7997 Views
- I also Faced
- E-Mail Answers
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
How to insert stored procedure result into temporary table?
How to create dbo table in sql server?
Where are full-text indexes stored?
Tell me about builtinadministrator?
What is store procedure? How do they work? When do you use?
Are semicolons required at the end of sql statements in sql server 2005?
What is scalar user-defined function?
What are the differences between char and varchar in ms sql server?
Explain about merge replications?
Does group by or order by come first?
Explain about system database?
What is the difference between a "where" clause and a "having" clause?
Is ssrs support other database except ms sql server?
How we can compare two database data?
What is a system database and what is a user database?
