是的,尝试这样的事情:
SELECT *FROM `YourTable`WHERE `YourColumn` IN ( SELECT `YourColumn` FROM `YourTable` GROUP BY `YourColumn` HAVING COUNT(*) > 1)