ORACLE分组统计科室字段相同科室的数量
匹配科室字典表统计科室字段相同科室的数量
select t.VISIT_DEPT as 科室编码,
a.DEPT_NAME as 科室名称,
count(t.VISIT_DEPT)as 就诊数量
from OUTPADM.CLINIC_MASTER t, DEPT_DICT a
where t.VISIT_DATE > to_date('2018/09/ 30', 'YYYY/MM/DD')
AND t.VISIT_DATE < to_date('2018/11/ 01', 'YYYY/MM/DD')
and a.DEPT_CODE = t.VISIT_DEPT
group by t.VISIT_DEPT,a.DEPT_NAME;分组统计科室字段相同科室的数量
select t.VISIT_DEPT as 科室编码,
count(t.VISIT_DEPT)as 就诊数量
from OUTPADM.CLINIC_MASTER t
where t.VISIT_DATE > to_date('2018/09/ 30', 'YYYY/MM/DD')
AND t.VISIT_DATE < to_date('2018/11/ 01', 'YYYY/MM/DD')
group by t.VISIT_DEPT;
您阅读本篇文章共花了： 