Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
Posted Tuesday, May 10, 2016 9:31 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:45 AM
Points: 8,328, Visits: 858
Thanks for the script.
Post #1784822
Posted Tuesday, May 10, 2016 10:30 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 12:37 PM
Points: 9,956, Visits: 9,363
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
Post #1784846
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse