select t2.*,t3.ncount from
(select groupid, count(id) as ncount from t_txlEmploy group by groupid) t3, t_txlgroup t2
where t2.id=t3.groupid(+)
group by t2.id,t3.groupid
構(gòu)架一張t3
表，字段為“集團(tuán)編號”，“集團(tuán)用戶數(shù)”
然后用“集團(tuán)表”和t3表再關(guān)聯(lián)