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;
转载于:https://www.cnblogs.com/ainidewen/p/6707525.html