就是,只保留一条(number累加),其他都删除, 有没有哪位大哥提供好点的思路?
2条回答
- threenewbee 2018-10-13 11:17关注
update table a set 数据 = (select sum(数据) from table b where a.id = b.id)
delete table where id in (select id, max(number) mn from table group by table where number < mn)本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报