Delete from( select column1, column2, row_number() over(partition by column1 order by column2 desc) rn from some_table ) where rn>1
Select allOpen in new window
select column1, column2, row_number() over(partition by column1 order by column2 desc) rn
from some_table
)
where rn=1
/