Delete From user WHERE ID in (SELECT MIN(ID) FROM user Group By userid having count(userid)>1 )
使用SQL删除表里某一列是重复的数据,只保留一条。
最新推荐文章于 2020-12-29 11:23:36 发布
Delete From user WHERE ID in (SELECT MIN(ID) FROM user Group By userid having count(userid)>1 )