ชุดคำสั่ง
SELECT distcode,
ampurname,
#s_death_diag_sex_age.hospcode,
SUM(result) AS total,
SUM(CASE WHEN cdisease.diagcode='i21' THEN result ELSE 0 END) AS 'i21',
SUM(CASE WHEN cdisease.diagcode='i211' THEN result ELSE 0 END) AS 'i211',
SUM(CASE WHEN cdisease.diagcode='i213' THEN result ELSE 0 END) AS 'i213',
SUM(CASE WHEN cdisease.diagcode='i214' THEN result ELSE 0 END) AS 'i214',
SUM(CASE WHEN cdisease.diagcode='i219' THEN result ELSE 0 END) AS 'i219',
SUM(CASE WHEN cdisease.diagcode='i24' THEN result ELSE 0 END) AS 'i24',
SUM(CASE WHEN cdisease.diagcode='i249' THEN result ELSE 0 END) AS 'i249',
SUM(CASE WHEN cdisease.diagcode='i25' THEN result ELSE 0 END) AS 'i25',
SUM(CASE WHEN cdisease.diagcode='i251' THEN result ELSE 0 END) AS 'i251',
SUM(CASE WHEN cdisease.diagcode='i256' THEN result ELSE 0 END) AS 'i256',
SUM(CASE WHEN cdisease.diagcode='i259' THEN result ELSE 0 END) AS 'i259'
FROM
s_death_diag_sex_age
INNER JOIN cdisease ON s_death_diag_sex_age.diagcode = cdisease.diagcode
INNER JOIN chospital on s_death_diag_sex_age.hospcode = chospital.hoscode
INNER JOIN campur ON chospital.distcode = campur.ampurcode
WHERE id='8881445af732eb166fa2470ba5046956' AND b_year = '2562' AND SUBSTR(areacode,1,2)='77'
AND cdisease.diagcode BETWEEN 'i20' AND 'i259' AND campur.changwatcode = '77'
GROUP BY distcode
ORDER BY distcode ASC
หมายเหตุ : ข้อมูลที่ใช้ในการประมวลเป็น HDC (จังหวัด) ตั้งแต่ 1 ตุลาคม 2562 ถึงวันที่เรียกดูรายงาน