and
predicate
Applies to: Databricks SQL Databricks Runtime
Returns the logical AND of expr1
and expr2
.
Syntax
expr1 and expr2
Arguments
expr1
: A BOOLEAN expressionexpr2
: 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