Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Sureshkumar Ramakrishnan Deleting Duplicate Records RE: Deleting Duplicate Records

  • 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"