โรงพยาบาลจอมพระ

select p.pttype,t.hipdata_code,o.hba1c,o.hn,o.vstdate,o.vn,s.pdx,s.dx0,s.dx1,s.dx2,s.dx3,s.dx4,s.dx5
from opdscreen o
join patient p on p.hn=o.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=o.vn
where (o.vstdate between ‘2013-10-01’ and ‘2014-06-31′)
and o.hba1c<7
and (t.hipdata_code=’UCS’)
and ((s.pdx like “e%”) or (s.dx0 like “e%”) or (s.dx2 like “e%”) or (s.dx3 like “e%”) or (s.dx4 like “e%”) or (s.dx5 like “e%”))
group by o.hn

select p.pttype,t.hipdata_code,o.hba1c,o.hn,o.vstdate,o.vn,s.pdx,s.dx0,s.dx1,s.dx2,s.dx3,s.dx4,s.dx5
from opdscreen o
join patient p on p.hn=o.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=o.vn
where (o.vstdate between ‘2013-10-01’ and ‘2014-06-31′)
and o.hba1c<>””
and (t.hipdata_code=’UCS’)
and ((s.pdx like “e%”) or (s.dx0 like “e%”) or (s.dx2 like “e%”) or (s.dx3 like “e%”) or (s.dx4 like “e%”) or (s.dx5 like “e%”))
group by o.hn

select p.pttype,t.hipdata_code,o.hba1c,o.hn,o.vstdate,o.vn,s.pdx,s.dx0,s.dx1,s.dx2,s.dx3,s.dx4,s.dx5
from opdscreen o
join patient p on p.hn=o.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=o.vn
where (o.vstdate between ‘2013-10-01’ and ‘2014-06-31’)
and o.hba1c<7
and ((s.pdx like “e%”) or (s.dx0 like “e%”) or (s.dx2 like “e%”) or (s.dx3 like “e%”) or (s.dx4 like “e%”) or (s.dx5 like “e%”))
group by o.hn

select p.pttype,t.hipdata_code,o.hba1c,o.hn,o.vstdate,o.vn,s.pdx,s.dx0,s.dx1,s.dx2,s.dx3,s.dx4,s.dx5
from opdscreen o
join patient p on p.hn=o.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=o.vn
where (o.vstdate between ‘2013-10-01’ and ‘2014-06-31’)
and o.hba1c<>””
and ((s.pdx like “e%”) or (s.dx0 like “e%”) or (s.dx2 like “e%”) or (s.dx3 like “e%”) or (s.dx4 like “e%”) or (s.dx5 like “e%”))
group by o.hn

select p.pttype,t.hipdata_code,o.hba1c,o.hn,o.vstdate,o.vn,o.bpd,o.bps,s.pdx,s.dx0,s.dx1,s.dx2,s.dx3,s.dx4,s.dx5
from opdscreen o
join patient p on p.hn=o.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=o.vn
where (o.vstdate between ‘2013-10-01’ and ‘2014-06-31′)
and (o.bps< 140 or o.bps <90)
and (t.hipdata_code=’UCS’)
and ((s.pdx like “i10”) or (s.dx0 like “i10”) or (s.dx2 like “i10”) or (s.dx3 like “i10”) or (s.dx4 like “i10”) or (s.dx5 like “i10”))
group by o.hn
order by o.vstdate desc

select p.pttype,t.hipdata_code,o.hba1c,o.hn,o.vstdate,o.vn,o.bpd,o.bps,s.pdx,s.dx0,s.dx1,s.dx2,s.dx3,s.dx4,s.dx5
from opdscreen o
join patient p on p.hn=o.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=o.vn
where (o.vstdate between ‘2013-10-01’ and ‘2014-06-31′)
and (o.bps< 140 or o.bps <90)
/* and (t.hipdata_code=’UCS’) */
and ((s.pdx like “i10”) or (s.dx0 like “i10”) or (s.dx2 like “i10”) or (s.dx3 like “i10”) or (s.dx4 like “i10”) or (s.dx5 like “i10”))
group by o.hn
order by o.vstdate desc

0

0