mysql查找name列相同的数据
select * from [dbo].[HROCDepartment]
where Name in (select Name from [dbo].[HROCDepartment]
group by Name having COUNT(*)>1)
order by Name
例二:mysql查找welder_info表中idcardnumber列相同数据大于一的数据
select * from welder_info
where idcardnumber in (select idcardnumber from welder_info
group by idcardnumber having COUNT(*)>1)
order by idcardnumber