delete duplicate records

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  May 14, 2009 at 11:56 pm

  #130104

  hi to all,

  how can i delete duplicate records in a table, if table ishaving the IDENTITY COLUMN.

  🙂

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  May 15, 2009 at 1:31 am

  #995123

  See the following link:

  http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=DuplicateRows&referringTitle=Home

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256

  --Ramesh
  

  ---