用SQL语句删除重复记录

只要我把重复数据列出来，再改寫刪除不就可以了？

1、我先把想要删除的数据列出来，如下：

 

1 SELECT  * FROM  Shirly  where  id<>(select max(id) from Shirly d where Shirly.spId =d.spId )
2 AND spId in (select spId from Shirly b GROUP BY spId HAVING COUNT(spId)>1)