delete t1
from titles_test t1 inner join titles_test t2 
where t1.emp_no=t2.emp_no and t1.id>t2.id;
select *
from titles_test;