删除emp_no重复的记录只保留最小的id对应的记录
删除emp_no重复的记录，只保留最小的id对应的记录。
https://www.nowcoder.com/practice/3d92551a6f6d4f1ebde272d20872cf05
delete from titles_test where id in (select b.id from (select *, row_number() over(partition by emp_no order by id) as ranking from titles_test) as b where b.ranking <> 1);
查看10道真题和解析
投递用友等公司10个岗位