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

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