DELETE FROM Table
WHERE ID NOT IN
(
SELECT MIN(ID)
FROM Table
GROUP BY alan1, alan2, alan3, ...
)

alan1, alan2 vs. tekrar eden bilgilerin bulunduğu kolon isimleridir