How to delete duplicated rows

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) ;

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!
This is specially for Alex Zeng. He is an Oracle Jockey.