delete from titles_test where id not in --删除来自表不等于id最小的列
(select *
from (select min(id)--子查询id最小的列
from titles_test
group by emp_no) a)

删除列通过where定位精准目标

语法：delete from 表名 where 唯一字段=或者not in 目标值