View Code
delete from StationInfo where StationID in (
select StationID from StationInfo group by StationID having COUNT(StationID)>1)