- โค้ด: เลือกทั้งหมด
select substr (t_visit.visit_begin_visit_time,1,7) as "month"
,count(distinct case when substr(t_diag_icd10.diag_icd10_number,1,3) in('J45','J46') and t_visit.f_visit_type_id in ('0') then t_visit.t_patient_id else null end) as "ASHmaคนOPDatER"
,count (distinct case when substr(t_diag_icd10.diag_icd10_number,1,3) in('J45','J46') and t_visit.f_visit_type_id in ('0') then t_visit.t_visit_id else null end) as "ครั้งOPDatER"
,count(distinct case when substr(t_diag_icd10.diag_icd10_number,1,3) in('J45','J46') and t_visit.f_visit_type_id in ('1') then t_visit.t_patient_id else null end) as "คนIPD"
,count (distinct case when substr(t_diag_icd10.diag_icd10_number,1,3) in('J45','J46') and t_visit.f_visit_type_id in ('1') then t_visit.t_visit_id else null end) as "ครั้งIPD"
,count (distinct case when substr(t_diag_icd10.diag_icd10_number,1,3) in('J45','J46') and order_common_name ilike '%E.T%' then t_visit.t_patient_id else null end) as "On ETคน"
,count (distinct case when substr(t_diag_icd10.diag_icd10_number,1,3) in('J45','J46') and order_common_name ilike '%E.T%' then t_visit.t_visit_id else null end) as "On ETครั้ง"
,count (distinct case when substr(t_diag_icd10.diag_icd10_number,1,3) in('J45','J46') and (t_visit.f_visit_opd_discharge_status_id = '52' or t_visit.f_visit_ipd_discharge_status_id ='9') then t_visit.t_patient_id else null end) as "DEATH"
from t_visit inner join t_diag_icd10 on t_visit.t_visit_id = t_diag_icd10.diag_icd10_vn
inner join t_visit_service on t_visit.t_visit_id = t_visit_service.t_visit_id
--จุดบริการห้องฉุกเฉิน
and t_visit_service.b_service_point_id ='2409144269314'
inner join t_order on t_visit.t_visit_id = t_order.t_visit_id and t_order.f_order_status_id <> '4'
where substr(t_visit.visit_begin_visit_time,1,10)
between substr (?,1,10) and substr(?,1,10)
and substr(t_diag_icd10.diag_icd10_number,1,3) in('J45','J46')
and t_visit.f_visit_status_id <> '4'
group by month
เอามาให้ลองปรับเป็นของ รพ.ตนเองนะครับ ต้นแบบโรงพยาบาลท้ายเหมือง
เอกสารอ้างอิง : http://dl.dropbox.com/u/39249953/2007_% ... %B8%94.pdf
