insert into table1
select id,
case when t>0 and t<=2 then 100+t
else case when t>2 and t<=4 then 200+t
else -----------等等
end
end as t
select id,
case when t>0 and t<=2 then 100+t
else case when t>2 and t<=4 then 200+t
else -----------等等
end
end as t
Insert TableName(id ,value)
Select 1,Case When t>0 And t<2 Then 100+t When t>2 And t<4 Then 200+t End