Dremio Cloud
Dremio Software
 
On this page

    Conditional

    Function Name Description
    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 ELSE statement, if present, or else will return NULL.
    COALESCE Evaluates the arguments in order and returns the value of the first expression that does not contain NULL.
    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 NULL and, if they are not equal, returns the value of the first expression.
    NVL Returns the value of the first expression, if it is not NULL. Otherwise, returns the value of the second expression.