SELECT
PROJECT_CODE,
COUNT( PROJECT_CODE)
FROM
meng_project_info
GROUP BY
PROJECT_CODE
HAVING
COUNT( PROJECT_CODE) > 1
结果:
![](https://img-blog.csdnimg.cn/img_convert/18ee2874cc22bf6bf3f3174b5e63c300.png)
SELECT
PROJECT_CODE,
COUNT( PROJECT_CODE)
FROM
meng_project_info
GROUP BY
PROJECT_CODE
HAVING
COUNT( PROJECT_CODE) > 1
结果: