DB应该有字段转型计算功能,但是必须保证该字段类型为数字类型;
字段[annual]为数字类型
select m.ANNUAL from MTITM_ITEMS m where m.item_cd='9999800015'
and m.annual='1'+2+3-4+1
DB应该有字段转型计算功能,但是必须保证该字段类型为数字类型;
字段[annual]为数字类型
select m.ANNUAL from MTITM_ITEMS m where m.item_cd='9999800015'
and m.annual='1'+2+3-4+1