Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Sureshkumar Ramakrishnan Deleting Duplicate Records RE: Deleting Duplicate Records
SwePeso
SSC-Dedicated
Points: 39752
More actions
November 24, 2008 at 12:46 pm
#902699
Ajay... Yes it does work.
DELETE t1
FROM (
SELECT ROW_NUMBER() OVER (PARTITION BY Col1 ORDER BY Col2 DESC) AS RecID
FROM Table1
) AS t1
WHERE RecID > 1
N 56°04'39.16"E 12°55'05.25"