Peter,

You can do it with CTE like this

WITH x As (select row_number() over (partition by id1, id2 order by id2) nr FROM MyTab)

delete FROM x where nr > 1

Thanks,

Oded