题解 | 越到后面越是这种题越不会
删除emp_no重复的记录,只保留最小的id对应的记录。
https://www.nowcoder.com/practice/3d92551a6f6d4f1ebde272d20872cf05
delete t1 from titles_test t1 inner join titles_test t2 where t1.emp_no=t2.emp_no and t1.id>t2.id; select * from titles_test;
删除emp_no重复的记录,只保留最小的id对应的记录。
https://www.nowcoder.com/practice/3d92551a6f6d4f1ebde272d20872cf05
delete t1 from titles_test t1 inner join titles_test t2 where t1.emp_no=t2.emp_no and t1.id>t2.id; select * from titles_test;
相关推荐