查看表中,某个字段是否是唯一的(没有重复的)

示例SQL:

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

结果:

posted @ 2022-02-18 13:43  残笑  阅读(247)  评论(0)    收藏  举报