Way to Delete duplicate rows in a table.

Question

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

gordon.cantor Grasshopper Points: 19 More actions · Answer 1

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.