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