Conditional Functions

This section provides reference information for the conditional functions in PlaidCloud Lakehouse.

[ NOT ] BETWEEN

Learn how to use the [ NOT ] BETWEEN conditional function in PlaidCloud Lakehouse. Returns true if the given numeric or string falls inside the...

[ NOT ] IN

Learn how to use the [ NOT ] IN conditional function in PlaidCloud Lakehouse. Checks whether a value is (or is not) in an explicit list. Includes syntax and...

AND

Learn how to use the AND conditional function in PlaidCloud Lakehouse. Conditional AND operator. Includes detailed syntax, examples, and usage reference.

CASE

Learn how to use the CASE conditional function in PlaidCloud Lakehouse. Handles IF/THEN logic. Includes detailed syntax, examples, and usage reference.

COALESCE

Learn how to use the COALESCE conditional function in PlaidCloud Lakehouse. Returns the first non-NULL expression within its arguments; if all arguments are...

Comparison Methods

Learn how to use the COMPARISON METHODS conditional function in PlaidCloud Lakehouse. These comparison methods are available in Analyze expressions.

ERROR_OR

Learn how to use the ERROR_OR conditional function in PlaidCloud Lakehouse. Returns the first non-error expression among its inputs. With syntax and examples.

GREATEST

Learn how to use the GREATEST conditional function in PlaidCloud Lakehouse. Returns the maximum value from a set of values. Includes syntax and examples.

IF

Learn how to use the IF conditional function in PlaidCloud Lakehouse. If is TRUE, it returns . See syntax and usage examples.

IFNULL

Learn how to use the IFNULL conditional function in PlaidCloud Lakehouse. If is NULL, returns , otherwise returns . Includes syntax...

IS [ NOT ] DISTINCT FROM

Learn how to use the IS [ NOT ] DISTINCT FROM conditional function in PlaidCloud Lakehouse. Compares whether two expressions are equal (or not equal) with...

IS_ERROR

Learn how to use the IS_ERROR conditional function in PlaidCloud Lakehouse. Returns a Boolean value indicating whether an expression is an error value.

IS_NOT_ERROR

Learn how to use the IS_NOT_ERROR conditional function in PlaidCloud Lakehouse. Returns a Boolean value indicating whether an expression is an error value.

IS_NOT_NULL

Learn how to use the IS_NOT_NULL conditional function in PlaidCloud Lakehouse. Checks whether a value is not NULL. Includes syntax and examples.

IS_NULL

Learn how to use the IS_NULL conditional function in PlaidCloud Lakehouse. Checks whether a value is NULL. Includes usage and syntax details.

LEAST

Learn how to use the LEAST conditional function in PlaidCloud Lakehouse. Returns the minimum value from a set of values. Includes syntax and examples.

NULLIF

Learn how to use the NULLIF conditional function in PlaidCloud Lakehouse. Returns NULL if two expressions are equal. Includes syntax and examples.

NVL

Learn how to use the NVL conditional function in PlaidCloud Lakehouse. If is NULL, returns , otherwise returns . With syntax and examples.

NVL2

Learn how to use the NVL2 conditional function in PlaidCloud Lakehouse. Returns if is not NULL; otherwise, it returns .

OR

Learn how to use the OR conditional function in PlaidCloud Lakehouse. Conditional OR operator. Includes detailed syntax, examples, and usage reference.