pasonic的专栏

原创 表中存在相同的记录，如何用SQL语句删除重复的？

1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断     select   *   from   people     where   peopleId   in   (select     peopleId     from     people     group     by     peopleId     having     count(peopleId)