select APPLICANT_DISTRICT,count(oid)from ut_visit_managegroup by APPLICANT_DISTRICTAPPLICANT_DISTRICT代表区县编号现在搜出来的结果是APPLICANT_DISTRICT | count(oid)
1 | 3
15 | 14区县名称保存在另一张表里。请问怎么可以一句SQL,直接显示区县的名称和数量。
1 | 3
15 | 14区县名称保存在另一张表里。请问怎么可以一句SQL,直接显示区县的名称和数量。
from ut_visit_manage a,区县名称表 b
where a.APPLICANT_DISTRICT = b.区县编号字段
group by b.区县名称字段
from 区县名称表,
(
select APPLICANT_DISTRICT,count(oid)
from ut_visit_manage
group by APPLICANT_DISTRICT) A
where
A.APPLICANT_DISTRICT = 区县名称表.编号