|BOOL_AND||Computes the boolean AND of two boolean expressions. Returns TRUE if both expressions evaluate to TRUE. Returns FALSE if one or both expression(s) evaluate(s) to FALSE.|
|BOOL_OR||Computes the boolean OR of two boolean expressions. Returns TRUE if one or both expressions evaluate to TRUE. Returns FALSE if both expressions evaluate to FALSE.|
|CASE||Evaluates a list of conditions and returns the first resulting true expression. If a true expression is not found, will return the
|COALESCE||Evaluates the arguments in order and returns the value of the first expression that does not contain
|GREATEST||Returns the largest value from a list of expressions.|
|LEAST||Returns the smallest value from a list of expressions.|
|NULLIF||Compares two expressions. If the values in each expression are equal, returns
|NVL||Returns the value of the first expression, if it is not
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.