sqlcookbook --删除重复记录

select * from dupes order by 1

结果如下：
    id  name
    -------------------
    1   napoleon
    2   danamite
    3   danamite
    4   she sells
    5   sea shells
    6   sea shells
    7   sea shells  

解决方案

delete from dupes 
    where id not in (
        select min(id) from tupes
            group by name
        )