尽量不用SELECT * 吧！！！！

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