SELECT
PROJECT_CODE,
COUNT( PROJECT_CODE)
FROM
meng_project_info
GROUP BY
PROJECT_CODE
HAVING
COUNT( PROJECT_CODE) > 1
结果:
![](https://i-blog.csdnimg.cn/blog_migrate/8d07febc4bcbc2107b28a816b23d6c3c.png)
SELECT
PROJECT_CODE,
COUNT( PROJECT_CODE)
FROM
meng_project_info
GROUP BY
PROJECT_CODE
HAVING
COUNT( PROJECT_CODE) > 1
结果: