21,886
社区成员
发帖
与我相关
我的任务
分享
select fStaff,count(intParent),count(chrDomain) from G_register as g,Users as u where g.intParent=u.IDUser and fStaff is not null and EPPStatus is not null and fStaff<>0 group by fStaff
select fStaff,count(intParent),count(chrDomain) from G_register as g,Users as u where g.intParent=u.IDUser and fStaff is not null and EPPStatus is not null and fStaff<>0 group by fStaff
(select fStaff,sum(intParent) from G_register as g,Users as u where g.intParent=u.IDUser order by fStaff)
select fstaff,count(*) as intParent
from G_register
group by fstaff;