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 repeatable read?
How you can change a cross join into an inner join?
what are the three command line utilities and what are their primary functions?
Do you know what is xpath?
What is policy based management (pbm)? : sql server database administration
What is the simplest way to create a new database in ms sql server?
What are the main sources of data?
What are joins in sql and what are the different types of joins?
What do you understand by the denormalisation?
How to recreate an existing index in ms sql server?
What is sql service broker?
What is the use of tempdb? What values does it hold?
When you use @@error and try-catch?
What is a rownum?
What is temporal data type?