Sql 删除重复项

View Code 
delete from StationInfo where StationID in (
select  StationID from StationInfo group by StationID having COUNT(StationID)>1)
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/kingteach/p/2054259.html