Skip to main content

or operator

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the logical OR of expr1 and expr2.

Syntax​

expr1 or expr2

Arguments​

  • expr1: A BOOLEAN expression.
  • expr2: A BOOLEAN expression.

Returns​

A BOOLEAN.

Examples​

SQL
> SELECT true or false;
true
> SELECT false or false;
false
> SELECT true or NULL;
true
> SELECT false or NULL;
NULL