例:删除图书表(book)中出版社有重复的记录,只保留一条 delete from book where 编号 not in (select max(编号) as 编号 from book group by 出版社)