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