来点野性

摘要： --查询出重复部门名称的信息1select * from cc_mstr as a ,(select cc_desc from cc_mstr group by cc_desc having count(*)>1) bwhere a.cc_desc =b.cc_desc --查询出重复部门名称的信息2select * from cc_mstr as a where (select count(*) from cc_mstr as b where a.cc_desc = b.cc_desc)>1--查询出重复部门名称的信息3select cc_descfrom cc_mstrgrou 阅读全文