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
- 8542 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
Can a table be moved to different filegroup?
Explain the difference between function and stored procedure?
How to find the list of fixed hard drive and free space on server?
What are indexes in sql?
How you can move data or databases between servers and databases in sql server?
What is the filtered index?
What are the new scripting capabilities of ssms? : sql server management studio
What is meant by indexing?
What does this statement do @@rowcount?
what are user defined datatypes? : Sql server database administration
Can you roll back the ddl statement in a trigger?
What security features are available for stored procedure?
How do I determine how many instances of sql server are installed on a computer?
What is replication with database mirroring? : sql server database administration
What are the differences between union, intersect, and minus operators?
