delete from titles_test
where id not in (
    select a.*
    from 
    (select min(id) from titles_test
    group by emp_no) a
)

不能一边删一边查，需要再套一层