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  阅读(237)  评论(0编辑  收藏  举报