--市医保药品目录外费用比例（住院）=市医保目录外药品总金额 / 市医保药品总金额
select 
round((select sum(round(lsdj00*ypzsl0,2)) from (
select a.lsdj00,a.ypzsl0 from yf_yzypsq a,zy_brxxb0 b where b.ybzxlb='2' and a.zyid00=b.zyid00 and 
a.jzrq00>='20160101' and a.jzrq00<='20160331' and a.zfbl00=1
union all
select a.lsdj00,a.ypzsl0 from yf_zycfmx a,zy_brxxb0 b,yf_zycf00 c where 
b.ybzxlb='2' and c.zyid00=b.zyid00 and a.cflsh0=c.cflsh0 and 
c.jzrq00>='20160101' and c.jzrq00<='20160331' and a.zfbl00=1))
/(select sum(round(lsdj00*ypzsl0,2)) from (
select a.lsdj00,a.ypzsl0 from yf_yzypsq a,zy_brxxb0 b where b.ybzxlb='2' and a.zyid00=b.zyid00 and 
a.jzrq00>='20160101' and a.jzrq00<='20160331' 
union all
select a.lsdj00,a.ypzsl0 from yf_zycfmx a,zy_brxxb0 b,yf_zycf00 c where 
b.ybzxlb='2' and c.zyid00=b.zyid00 and a.cflsh0=c.cflsh0 and 
c.jzrq00>='20160101' and c.jzrq00<='20160331' )),4)*100||'%'
from dual