MySQL单表删除重复列SQL语句

DELETE 
FROM
	video 
WHERE
	url 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 )