DELETE D
FROM
(
SELECT *, RN = ROW_NUMBER() OVER (PARTITION BY FLD_MAPNAME , FLD_X , FLD_Y , FLD_MONNAME
ORDER BY FLD_MAPNAME , FLD_X , FLD_Y , FLD_MONNAME)
FROM yourtable
) D
WHERE RN <> 1
Do make sure you have backup before executing it, it case it is not what you wanted
KH
Time is always against us
not sure if correct place but...
Posted - 02/12/2013 : 18:05:46
