All functions > CONDITIONAL
All functions in the CONDITIONAL category.
| Function | DuckDB | Trino | Serving | Description |
|---|---|---|---|---|
NULLIF() | ✓ | ✓ | ✓ | Returns NULL when two values compare equal; otherwise returns the first value |
IF() | ✓ | ✓ | ✓ | Returns one value if a condition is true, another if false |
CASE WHEN | ✓ | ✓ | ✓ | Returns the result of the first condition that evaluates to true |
CASE WHEN VALUE | ✓ | ✓ | ✓ | Returns the result corresponding to the first matching value in a simple case expression |
COALESCE(...) | ✓ | ✓ | ✓ | Returns the first non-NULL value from a list of values |
Summary
Functions in this category: 5
This documentation is automatically generated from the FeatureMesh registry.