删除emp_no重复的记录，只保留最小的id对应的记录。#
删除emp_no重复的记录，只保留最小的id对应的记录。
https://www.nowcoder.com/practice/3d92551a6f6d4f1ebde272d20872cf05
delete
from titles_test
where (emp_no, id) not in (select *
from (select emp_no, min(id) as id
from titles_test
group by emp_no) as f);
投递美团等公司9个岗位