Delete duplicate records from the table?(Table must have
unique id)
Answer Posted / manoj
Check following blog post on how to first identify & then delete duplicate records: http://sqlwithmanoj.wordpress.com/2011/10/14/identify-delete-duplicate-records-from-a-table/
This lists multiple ways to delete duplicates.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between truncate and delete commands?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What are window functions in sql server?
Why should one not prefix user stored procedures with ‘sp_’?
What is the difference between seek predicate and predicate?
How to apply cascading referential integrity in place of triggers?
what is the sql equivaent of the dataset relation object ?
What is an index in a database?
Explain log shipping?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can you please explain the difference between function and stored procedure?
How do I start sql server 2017?
Explain features of analysis services?
How to backup encryption key ?
Can I use sql azure as a backup with log shipping or database mirroring?