and predicate (Databricks SQL)

Returns the logical AND of expr1 and expr2.

Syntax

expr1 and expr2

Arguments

• expr1: A BOOLEAN expression

• expr2: A BOOLEAN expression

Returns

A BOOLEAN.

Examples

> SELECT true and true;
 true
> SELECT true and false;
 false
> SELECT true and NULL;
 NULL
> SELECT false and NULL;
 false

Related functions

• or operator (Databricks SQL)

• not operator (Databricks SQL)