Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8757 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 take backup bcp out for a column in table in sql server?
What are xml indexes?
Explain full-text query in sql server?
How can we migrate from SQL server to SQL Azure?
Comment,Datatypes are unlimited
What is side by side migration in sql server?
What are the components of dbms?
Describe and explain about SQL native client?
What is the downside of using udf?
What are different types of collation sensitivity?
Tell me when is the update_statistics command used?
What is acid properties?
How to rebuild all indexes on a single table?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
How to insert and update data into a table with "insert" and "update" statements?
