IS [NOT] DISTINCT FROM
Compares two expressions to determine whether they have the same or different values. NULLs are considered as comparable values.
IS [NOT] DISTINCT FROM(expression any) → boolean
- expression: Can be a general expression of any Dremio-supported data type.
ExamplesIS [NOT] DISTINCT FROM example
IS [NOT] DISTINCT FROM example
SELECT NULL IS DISTINCT FROM NULL -- False
SELECT NULL IS NOT DISTINCT FROM NULL -- True
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.