Query ช่วยกรองโรคตามเกณฑ์การตรวจสอบ IPD 



SELECT
p.hn,
a.an,
p.cid,
p.fname,
p.lname,
a.sex,
a.age_y,
a.dchdate,
a.pdx
FROM
an_stat AS a
INNER JOIN patient p ON a.hn = p.hn
WHERE
a.dchdate BETWEEN '20161001' AND '20161231'
AND
((SUBSTR(a.pdx,1,1) in('A','B','E','I','J','K','M','O','R','S','Z')
OR
SUBSTR(a.pdx,1,3) BETWEEN 'D50' AND 'D89'))