sql script

delete from titles_test where id in 
(select * from (select max(id) as id from titles_test group by emp_no having count(*)>1) as tmp);