Way to Delete duplicate rows in a table.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by BINU PRASAD.M » Way to Delete duplicate rows in a table.

Way to Delete duplicate rows in a table.

Rate Topic

Display Mode

Topic Options

Author

Message

BINU PRASAD.M

Posted Sunday, September 23, 2007 6:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 26, 2012 12:36 PM
Points: 4, Visits: 36

New Post available for script for SQL 2005 or higher.
http://www.sqlservercentral.com/Forums/Topic1307956-543-1.aspx

Post #401755

gordon.cantor

Posted Wednesday, November 21, 2007 7:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 25, 2009 9:54 AM
Points: 1, Visits: 7

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.

Post #424605

« Prev Topic | Next Topic »

Permissions