thesqua.re interview question

How to find duplicate values in SQL and delete the latest one.