SQL CASE
Introduction
The CASE expression is used to implement if-then logic.
Syntax
- CASE input_expression
WHEN compare1 THEN result1
[WHEN compare2 THEN result2]...
[ELSE resultX]
END - CASE
WHEN condition1 THEN result1
[WHEN condition2 THEN result2]...
[ELSE resultX]
END
Remarks
The simple CASE expression returns the first result whose compareX value is equal to the input_expression.
The searched CASE expression returns the first result whose conditionX is true.
