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:48 pm
#902700
harsha.bhagat1
SELECT ddatetime, col1, col2
FROM (select ddatetime, col1, col2, row_number() over (partition by ddatetime, col1, col2 order by ddatetime) as recid
from table1
) as d
where recid > 1
N 56°04'39.16"E 12°55'05.25"