pms主键

delete from pms未关联数据 t1
where t1.rowid >
(select min(rowid) from pms未关联数据 t2
where t1.pms主键 = t2.pms主键
group by pms主键
having count(pms主键) > 1);