显示表中重复数据,并显示重复条数

SELECT EXU_DEPARTMENT,count(EXU_DEPARTMENT) as count 
FROM EXA_USER 
GROUP BY EXU_DEPARTMENT HAVING count(EXU_DEPARTMENT) >1 
ORDER BY count DESC;

  

posted @ 2017-04-14 10:23  听浪  阅读(229)  评论(0)    收藏  举报