示例SQL:

SELECT cms_product_code,COUNT(1) from new_product_prepare fsp GROUP BY cms_product_code HAVING COUNT(1)>1

结果: