The simple form of case
allows one expression in the when clause. With the comma-separated form, it accepts a list of expressions.
SELECT CASE column_name WHEN 0, 1, 2 THEN 'good'
WHEN 3, 7, 9 THEN 'bad'
END
FROM …
Tutorial: Case
— Conditional Expressions
Better supported alternative: case when …
(searched case).
The extended case
expression is defined in ISO/IEC 9075:2016-2 as optional feature F263, “Comma-separated predicates in simple CASE
expression”.
The essence of SQL tuning in 200 pages
Buy on Amazon
(paperback only)
Paperback and PDF also available at Markus’ store.
Markus offers SQL training and consulting for developers working at companies of any size.
Learn more »