Conditional Functions
| Method | Definition |
|---|---|
| case_when | Returns the conditional statement of the input arguments. |
| coalesce | Returns the value of the first non-null expression in the list. |
| decode | Compares expression to each search value one by one. |
| nullifzero | Evaluates to NULL if the value in the expression is 0. |
| zeroifnull | Evaluates to 0 if the expression is NULL. |