create proc proc_name as select case when 基本工资 between 3000 and 3999 then 基本工资*(1-0.05) when 基本工资 between 4000 and 4999 then 基本工资*(1-0.1) when 基本工资 >=5000 then 基本工资*(1-0.15) end from tb
--直接SQL语句中用case when即可select case when 基本工资 between 3000 and 3999 then 基本工资 * 0.95 when 基本工资 between 4000 and 4999 then 基本工资 * 0.90 when 基本工资 >= 5000 then 基本工资 * 0.85 end from tb 实发工资
如果要用存储过程,则把语句放入即可. create procedure my_proc as select case when 基本工资 between 3000 and 3999 then 基本工资 * 0.95 when 基本工资 between 4000 and 4999 then 基本工资 * 0.90 when 基本工资 >= 5000 then 基本工资 * 0.85 end from tb 实发工资 go
as
select case when 基本工资 between 3000 and 3999 then 基本工资*(1-0.05)
when 基本工资 between 4000 and 4999 then 基本工资*(1-0.1)
when 基本工资 >=5000 then 基本工资*(1-0.15)
end
from tb
when 基本工资 between 4000 and 4999 then 基本工资 * 0.90
when 基本工资 >= 5000 then 基本工资 * 0.85
end
from tb 实发工资
create procedure my_proc
as
select case when 基本工资 between 3000 and 3999 then 基本工资 * 0.95
when 基本工资 between 4000 and 4999 then 基本工资 * 0.90
when 基本工资 >= 5000 then 基本工资 * 0.85
end
from tb 实发工资
go