显示表中重复数据,并显示重复条数
SELECT EXU_DEPARTMENT,count(EXU_DEPARTMENT) as count FROM EXA_USER GROUP BY EXU_DEPARTMENT HAVING count(EXU_DEPARTMENT) >1 ORDER BY count DESC;
SELECT EXU_DEPARTMENT,count(EXU_DEPARTMENT) as count FROM EXA_USER GROUP BY EXU_DEPARTMENT HAVING count(EXU_DEPARTMENT) >1 ORDER BY count DESC;