用select * from 子查询创建新的中间表， 避免删记录的时候查询


delete from titles_test
where id not IN
(select * from 
(select min(id)
from titles_test
group by emp_no)a);