CASE ... WHEN...ELSE ... END

1.CASE ... WHEN...ELSE ... END

SELECT 
CASE WHEN  factor_code = 'a05024'
THEN  '因子一'
WHEN  factor_code = 'a34004'
THEN  '因子二'
WHEN  factor_code = 'a05024'
THEN  '因子三'
END '因子类别'
FROM t_excess_data_ga

2.CASE column WHEN... THEN ...ElSE...END 

SELECT 
CASE factor_code
WHEN 'a05024' THEN '因子一'
WHEN 'a34004' THEN '因子二'
WHEN 'a05024' THEN '因子三'
ELSE '其他因子' 
END '因子类别'
FROM t_excess_data_gas