Delete duplicate records from the table?(Table must have
unique id)
- 7 Answers
- 11136 Views
- TCS, Thomson Reuters, I also Faced
- E-Mail Answers
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 are subqueries in sql server?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What are the ways available in sql server to execute sql statements?
What is data source in connection string?
How raid can influence database performance?
Which tcp/ip port does the sql server run on? How can it be changed?
what is the difference between count(*) and count(1) ?
What is global temp table?
What are the advantages of stored procedure in sql server?
Can I save my report as html, excel or word? : sql server management studio
How to defragment table indexes?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Do you know what is sql service broker?
What is dirty read?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
