查询重复的记录

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

posted @ 2018-03-01 15:36  暗渡陈仓xy  阅读(100)  评论(0)  编辑  收藏  举报