不是太懂你的意思,大致思想是select col from tb group by col having count(1) > 1
select,casetelephone from(select distinct a.casetelephone,a.casename from(select casetelephone,casename from casemessage b group by casetelephone,casename having count(casetelephone)>=2)a inner join casemessage bona.casetelephone=b.casetelephone and a.casename=b.casename b group by casetelephone having count(*)>=2
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货