Skip to main content

and predicate

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

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​

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