MySQL单表删除重复列SQL语句

DELETE FROMvideo WHEREurl IN ( SELECT id FROM ( SELECT url AS id FROM video GROUP BY url HAVING count( url ) > 1 ) a ) AND id NOT IN ( SELECT pid FROM ( SELECT min( id ) AS pid FROM video GROUP BY url HAVING count( url ) > 1 ) b )