select a.* from tbl as a
inner join (select 名称,负责人
from tbl
group by 名称,负责人
having count(*)>1) as b
on a.名称=b.名称 and a.负责人=b.负责人
inner join (select 名称,负责人
from tbl
group by 名称,负责人
having count(*)>1) as b
on a.名称=b.名称 and a.负责人=b.负责人
from tb
group by 编码,名称,负责人
having count(*)>1
where a.名称=b.名称 and a.负责人=b.负责人
where a.名称=b.名称 and a.负责人=b.负责人
from tablename a join
( select 名称,负责人 from tablename group by 名称,负责人 having count(*)>1) b
on a.名称=b.名称 and a.负责人=b.负责人
from t a
where (select count(*) from t where 名称=a.名称 and 负责人=a.负责人)>1
select a.编码,b.名称,b.负责人tb a,
(
select 名称,负责人
from tb
group by 名称,负责人
having count(*)>1) b
where a.名称=b.名称 and a.负责人=b.负责人