题解 | #删除emp_no重复的记录，只保留最小的id对应的记录。#
删除emp_no重复的记录，只保留最小的id对应的记录。
http://www.nowcoder.com/practice/3d92551a6f6d4f1ebde272d20872cf05
sqlite:
delete from titles_test
where id not in (select min(id) from titles_test group by emp_no)
mysql:
delete from titles_test
where id not in (select * from (select min(id) from titles_test group by emp_no))
华为工作强度 840人发布
投递美团等公司10个岗位 >
