case
when 工资 in ('100','200','300','500') then 'a'
when 工资 in ('400','600','700','800') then 'b'
else 'c'
end
when 工资 in ('100','200','300','500') then 'a'
when 工资 in ('400','600','700','800') then 'b'
else 'c'
end
-----------------
100 a
200 a
300 a
500 a
......然后用连接表处理或者做个函数或者吗:
case When 工资 In('100','200','300','500') then 'a'
When 工资 In('400','600','700','800') then 'b'
else 'c'
end