delete from 维修 where exists(select 1 from 维修 a where a.id>维修.id and 维修.电话=a.电话 and soso)
一条删除重复数据且保留一条的SQL
最新推荐文章于 2023-07-15 11:19:18 发布
delete from 维修 where exists(select 1 from 维修 a where a.id>维修.id and 维修.电话=a.电话 and soso)