根据指定字段删除表中的重复数据

SQL：

DELETE FROM article
WHERE id NOT IN (
  SELECT *
  FROM (
         SELECT min(id)
         FROM
           article
         GROUP BY
           articleNo
         HAVING
           count(*) > 1
       ) a
)
      AND articleNo IN (
  SELECT *
  FROM (
         SELECT articleNo
         FROM article
         GROUP BY
           articleNo
         HAVING
           count(*) > 1
       ) b
);

其中，“article”为表名，“articleNo”为不允许重复的字段名