How to delete duplicate records ? [Resolved]

Posted by Kirthiga under Sql Server on 6/25/2012 | Points: 10 | Views : 2673 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to delete duplicate records in sql server without creating a temporary table ?

In my table im having 6000 records. Some rows are repeated two or three times.
I want to delete those records without transfering them into another table.

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajkatie on: 6/25/2012 [Member] [MVP] Gold | Points: 25

0	Kindly refer following link http://blog.sqlauthority.com/2009/06/23/sql-server-2005-2008-delete-duplicate-rows/ Rajesh Patel R.P.A Developer \| Developer Trainer \| Clean Code Evangelist Kirthiga, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sriramnandha on: 6/26/2012 [Member] Starter | Points: 25

0	DELETE FROM TABLENAME WHERE ID NOT IN ( SELECT MAX(ID) FROM TABLENAME GROUP BY COLUMNNAME) Hope this will help Regards Sriram.R sriram Kirthiga, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sriramnandha on: 6/26/2012 [Member] Starter | Points: 25

0	DELETE FROM table_name A WHERE ROWID > ( SELECT min(rowid) FROM table_name B WHERE A.key_values = B.key_values) sriram Kirthiga, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Weblorquins on: 7/8/2012 [Member] Starter | Points: 25

0	Delete From TableName Where ID Not IN { Select MAX(ID) From TableName Group By Col1, Col2... } http://sqlserver4us.blogspot.in/2012/07/how-to-delete-duplicate-records-in-sql.html For more SQL server Interview question and answer click below link http://sqlserver4us.blogspot.in Kirthiga, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts