备忘123

select * from 设备基本表 where 所属单位 = '金佳矿' and( 设备状态 <> '在用' and cast(设备余值 as float)/cast(设备原值 as float)<=0.3 or datediff(month,(select replace(replace(replace(投入年月,'年','-'),'月','-'),'日','')),getdate())>=cast(折旧年限 as int)*12)