CASE
Parameter | Description |
---|---|
condition | An expression that evaluates to a BOOLEAN value. |
result | A value or an expression that evaluates to a value. The CASE expression returns result if its associated condition evaluates to true. |
Parameter | Description |
---|---|
expression | An expression that evaluates to a value. expression is computed in the first place and its value will be compared with value in the WHEN clause. |
value | A value or an expression that evaluates to a value. Each value is a potential match for the expression. |
result | A value or an expression that evaluates to a value. The CASE expression returns result if its associated value matches the expression. |
COALESCE
NULLIF
greatest
least