deletefrom am_sn_list
where id in(select id
from(select id, sn,
row_number()over(partitionby sn orderby id)as row_num
from am_sn_list) d
where row_num >1);
mysql8利用窗口函数删除重复数据,保留ID较小的数据mysql8引入了窗口函数mysql8引入了窗口函数需求:需要删除重复数据保留较小ID的记录deletefrom am_sn_listwhere id in ( select id from ( select id, sn, row_number() over (partition by sn order by id) as row_num from am_sn_list) d where row_nu