2017年4月14日
显示表中重复数据,并显示重复条数
摘要： 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 听浪 阅读(218) 评论(0) 推荐(0) 编辑