去重复保留一条数据

DELETE A FROM book A
JOIN (
    SELECT MIN(id) id,authorID,bookName 
    FROM book
    GROUP BY authorID,bookName
    HAVING COUNT(1) > 1
) TMP ON A.authorID= TMP.authorID AND A.bookName =TMP.bookName AND A.id <> TMP.id
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/zhm001/p/14543312.html