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.