7,714
社区成员
发帖
与我相关
我的任务
分享
select a.thename,a.selfcode,a.parentcode,count(b.selfcode) as cnt from glasstype a,glasstype b
where a.parentcode='-1' and a.selfcode=b.parentcode
group by a.thename,a.selfcode,a.parentcode,a.theindex
order by a.theindex,a.selfcode