oracle如何能实现类似IIF函数在功能,如:工龄在0-10范围,工龄工资为3元一年,11-20范围的是5元每年,大于20的是10元每年.
工龄工资对应字段:AgePay,工龄字段:Age
IIF语句为
select Age,iif(Age>0 and Age<=10,Age*3,Age>=11 and Age<=20,Age*5,Age>=21,Age*10) AgePay from Table--
工龄工资对应字段:AgePay,工龄字段:Age
IIF语句为
select Age,iif(Age>0 and Age<=10,Age*3,Age>=11 and Age<=20,Age*5,Age>=21,Age*10) AgePay from Table--
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货