select * from t t1,(select renwu,qiye,count(distinct quyu) from t group by t.renwu,qiye having count(distinct quyu)>1)t2 where t1.renwu=t2.renwu and t1.qiye=t2.qiye
我用你的测试数据进行了测试,结果是对的啊: 思路如下: 子查询: select renwu, qiye, count(distinct quyu) from t group by t.renwu, qiye having count(distinct quyu) > 1 这里求出同一个任务和企业的不同的区域个数(因为加了distinct,所以是不同区域),然后用having count(distinct quyu) > 1筛选出存在多个不同区域的数据,最后再和主表进行关联
select * from t t1,(select renwu,qiye,count(distinct quyu) from t group by t.renwu,qiye having count(distinct quyu)>1)t2
where t1.renwu=t2.renwu and t1.qiye=t2.qiye
思路如下:
子查询:
select renwu, qiye, count(distinct quyu)
from t
group by t.renwu, qiye
having count(distinct quyu) > 1
这里求出同一个任务和企业的不同的区域个数(因为加了distinct,所以是不同区域),然后用having count(distinct quyu) > 1筛选出存在多个不同区域的数据,最后再和主表进行关联