无标题文章

DELETE
FROM test3
WHERE id NOT IN
(SELECT a.id
FROM
(SELECT min(id) AS id
FROM test3
GROUP BY book_id,
line_num HAVING count(*) > 1) a)