SQL中case语句的两种用法:
① 简单Case语句,语法如下:
CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END
示例如下:
SELECT (CASE value WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'more' END) value from myValue ;
②case搜索函数,语法如下:
CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END
示例如下:
select (CASE WHEN sex = '1' THEN '男' WHEN sex = '2' THEN '女' ELSE '其他' END) gender
from myValue;