query visit OPD คนไข้ห้องฟัน

  1. Overview
  2. HosXP
  3. Query
  4. query visit OPD คนไข้ห้องฟัน

OPD

SELECT
    COUNT(DISTINCT o.vn)
FROM
    ovst AS o
LEFT JOIN
    patient AS p ON o.hn = p.hn
LEFT JOIN
    kskdepartment AS k ON o.main_dep = k.depcode
WHERE
o.main_dep = '003'
and o.vstdate between '2024-10-01' AND '2025-06-30'
AND TIMESTAMPDIFF(YEAR, p.birthday, o.vstdate) BETWEEN 15 AND 39