Sometimes we need to duplicated rows in a table. We may use row_number() function.
This example is to delete rows with duplicated email_addr.
delete users where rowid in (
select rid from
(select rowid rid,row_number() over(partition by email_addr order by userid desc) rn from users)
where rn > 1) ;
Filed under: Data Management
