--SQLServer case <field> when <if1> then <value> end
select id,
class=
case age
when 12 then '一年级' ---else '其他'
when 13 then ' 二年级'
when 14 then '三年级'
end
from student
--oracle decode(<field>,<if1>,<value1>,<if2>,<value2>,<else value>)
select id,
decode(age,12,'一年级') from student