题解 | #删除emp_no重复的记录，只保留最小的id对应的记录。#

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

delete 和子查询的联动运用