2019-10-16

select distinct 医保类别 from pf.dbo.住院收费表

select * into pf.dbo.table1
from pf.dbo.住院收费表 where 医保类别='居民医保'

image.png

delete from pf.dbo.table1 where 医保类别<>'门统'

select convert(float,医保头筹支付金额B1)-(CONVERT(float,医疗费用金额)-200 )*0.35 as 超额
from pf.dbo.table1
order by 超额 desc

image.png