SELECT  

CASE airway_point_type_id

WHEN 1 THEN ‘VOR‘

WHEN 2 THEN ‘VOR/DME‘

WHEN 3 THEN ‘NDB‘

WHEN 10 THEN ‘P字点‘

WHEN 11 THEN ‘五字代码点‘

ELSE ‘其它‘ END

航路点类型

FROM AIRWAY_POINT

GROUP BY AIRWAY_POINT_TYPE_ID

2015.7.17 case when then else end用法Oralcle与SQLserver一致