Way to Delete duplicate rows in a table.

• BINU PRASAD.M

  SSC Enthusiast

  Points: 120

  More actions

  September 23, 2007 at 6:18 pm

  #175010

  New Post available for script for SQL 2005 or higher.

  http://www.sqlservercentral.com/Forums/Topic1307956-543-1.aspx

• gordon.cantor

  Grasshopper

  Points: 19

  More actions

  November 21, 2007 at 7:47 am

  #753109

  Binu or others,

  Here is the situation. Lets say I have a table with 5 fields. A "duplicate row" will have the same data in 4 of the fields, while the 5th field (submit date) will be different. What I want to do is display in a T-SQL query all unique records along with the duplicate rows that have the latest submit date.

  Any suggestions will be appreciated.

  Thanks,

  Gordon C.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 10, 2016 at 9:31 am

  #1877868

  Thanks for the script.

• Ed Wagner

  SSC Guru

  Points: 287024

  More actions

  May 10, 2016 at 10:30 am

  #1877890

  Iwas Bornready (5/10/2016)

  ---

  Thanks for the script.

  This thread is 8 1/2 years old. You posted a reply with no substance to a thread that nobody reads any more.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions