or operator

Applies to: Databricks SQL 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

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

Related functions

• and predicate
• or operator
• not operator
• ! (bang sign) operator