Sql 删除重复项

View Code 
delete from StationInfo where StationID in (
select  StationID from StationInfo group by StationID having COUNT(StationID)>1)
posted @ 2011-05-23 13:14  Wythe  阅读(243)  评论(0)  编辑  收藏  举报