All functions > COMPARISON

All functions in the COMPARISON category.

Equality

FunctionDuckDBTrinoServingDescription
= [equals]✓✓✓Returns TRUE if the first value equals the second value
!= [not]✓✓✓Returns TRUE if the first value does not equal the second value
IS NULL✓✓✓Returns TRUE if the expression evaluates to NULL.
IS NOT NULL✓✓✓Returns TRUE if the expression does NOT evaluate to NULL.
DISPLAYS AS✓✓✓Returns TRUE if two values are not distinct, treating NULL values as comparable.
IS NOT DISTINCT FROM✓✓✓Returns TRUE if two values are not distinct, treating NULL values as comparable (SQL-standard...
NOT DISPLAYS AS✓✓✓Returns TRUE if two values are distinct, treating NULL values as comparable.
IS DISTINCT FROM✓✓✓Returns TRUE if two values are distinct, treating NULL values as comparable (SQL-standard spelling).

Ordering

FunctionDuckDBTrinoServingDescription
< [less]✓✓✓Returns TRUE if the first value is strictly less than the second value
<= [less]✓✓✓Returns TRUE if the first value is less than or equal to the second value
> [greater]✓✓✓Returns TRUE if the first value is strictly greater than the second value
>= [greater]✓✓✓Returns TRUE if the first value is greater than or equal to the second value
BETWEEN✓✓✓Returns TRUE if a value is within a specified range (inclusive)
NOT BETWEEN✓✓✓Returns TRUE if a value is NOT within a specified range (inclusive).
LEAST(...)✓✓✓Returns the least (minimum) value from a list of arguments.
GREATEST(...)✓✓✓Returns the greatest (maximum) value from a list of arguments.

Pattern Matching

FunctionDuckDBTrinoServingDescription
LIKE✓✓✓Returns TRUE if a string matches a specified pattern with wildcards.
NOT LIKE✓✓✓Returns TRUE if a string does NOT match a specified pattern with wildcards.
LIKE multiple✓✓✓Case-sensitive or case-insensitive pattern matching: `LIKE` / `ILIKE` with `ANY`, `ALL`, or `NONE`...

Set Operations

FunctionDuckDBTrinoServingDescription
IN✓✓✓Returns TRUE if a value exists in a list of values.
NOT IN✓✓✓Returns TRUE if a value does NOT exist in a list of values.

Summary
Functions in this category: 21

This documentation is automatically generated from the FeatureMesh registry.

Last update at: 2026/08/04 11:25:38