Contents
qry
SELECT
ri.*,
CONCAT(HF.hr_prefix_name,HP.hr_fname,' ',HP.hr_lname) AS fullname,
CONCAT(rip.HR_POSITION,'',IFNULL(rip.HR_LAVEL,'')) AS HR_PERSON_LAVEL,
CONCAT(ri.USER_POST_POSITIO[...]
โปรแกรม SQL ประเมิน รพ.สต.ติดดาว ปี 65
JHCis
select visit.pcucode
,visit.visitdate
,sum(case when (date(visit.dateupdate) BETWEEN visit.visitdate AND DATE_ADD(visit.visitdate,INTERVAL 1 DAY) )then 1 else 0 end) as onestopservice
,sum(case when [...]