delete from titles_test
where id not in (
    select *
    from (
        select min(id) as min_id
        from titles_test
        group by emp_no
    ) temp
)