重复的 记录 删除，保留一条的sql 语句

1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
select * from [JMTiaoMaCRMX]
where [SeriarNumber] in (select [SeriarNumber] from [JMTiaoMaCRMX] group by [SeriarNumber] having count([SeriarNumber]) > 1)

2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录
delete from [JMTiaoMaCRMX]
where   [SeriarNumber] in (select [SeriarNumber]    from [JMTiaoMaCRMX] group by [SeriarNumber]      having count([SeriarNumber]) > 1)
and   id not in (select min(id) from [JMTiaoMaCRMX] group by [SeriarNumber]     having count([SeriarNumber])>1)

and  SeriarNumber =202108140992