查询重复的记录

SELECT project_no,count(project_no) AS count FROM yt_project GROUP BY project_no HAVING count > 1