34,838
社区成员




select * from table where jzbhid=clbhid
select distinct jzbhid,clbhid from talbe1
select distinct jzbhid,clbhid from talbe1
select table1.* from table1,
(select jzbhid,clbhid,count(*) from table1 group by jzbhid,clbhid having count(*)>1) t
where table1.jzbhid = t.jzbhid and table1.clbhid = t.clbhid