MySQL 查询所有重复的记录

SELECT pm_code,COUNT(pm_code) AS item_num FROM crm_product_master AS pm
GROUP BY pm_code
ORDER BY item_num DESC