查看表中,某个字段是否是唯一的(没有重复的)
示例SQL:
SELECT cms_product_code,COUNT(1) from new_product_prepare fsp GROUP BY cms_product_code HAVING COUNT(1)>1
结果:
示例SQL:
SELECT cms_product_code,COUNT(1) from new_product_prepare fsp GROUP BY cms_product_code HAVING COUNT(1)>1
结果: