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一致
原文：http://www.cnblogs.com/mol1995/p/5964896.html