not operator

October 10, 2023

Applies to: Databricks SQL Databricks Runtime

Returns logical negation of the argument. This operator is an alias for ! (bang sign) operator.

Syntax

Cópia de

not expr

Examples

Cópia de

SQL

> SELECT not true;
 false
> SELECT not false;
 true
> SELECT  not NULL;
 NULL