CASE case_value
WHEN when_value THEN statement_list[WHEN when_value THEN statement_list] ...
[ELSE statement_list]
END CASE
或者
CASE
WHEN search_condition THEN statement_list
[WHEN search_condition THEN statement_list] ...
[ELSE statement_list]
END CASE
demo
SELECT
CASE
WHEN score = 10
THEN '10'
WHEN score = 23.87
THEN '23.87'
ELSE 'not 10 and 23.87'
END
FROM score_test