Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Way to Delete duplicate rows in a table. Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 6:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 7:21 PM
Points: 4, Visits: 43
New Post available for script for SQL 2005 or higher.
http://www.sqlservercentral.com/Forums/Topic1307956-543-1.aspx
Post #401755
Posted Wednesday, November 21, 2007 7:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse