適用於：
Databricks SQL Databricks Runtime
如果 true 等於 expr1，則傳回 expr2，否則傳回 false。 此函數相當於==（eq eq sign）運算子。
語法
expr1 = expr2
引數
-
expr1：任何可比較類型的表達式。 -
expr2：與 共用最不通用類型的expr1表達式。
傳回
A BOOLEAN。
範例
> SELECT 2 = 2;
true
> SELECT 1 = '1';
true
> SELECT true = NULL;
NULL
> SELECT equal_null(true, NULL);
false
> SELECT NULL = NULL;
NULL
> SELECT equal_null(NULL, NULL);
true
-- By default string comparisons are trailing space sensitive
-- This can be overridden by using the COLLATE clause
> SELECT 'hello' = 'hello ' AS default,
'hello' = 'hello ' COLLATE UTF8_BINARY AS utf8_binary,
'hello' = 'hello ' COLLATE UTF8_BINARY_RTRIM AS rtrim;
default utf8_binary rtrim
------- ----------- -----
false false true
-- By default string comparisons are trailing space sensitive
-- This can be overridden by using the COLLATE clause
> SELECT 'world ' = 'world ' AS default,
'world ' = 'world ' COLLATE UTF8_BINARY AS utf8_binary,
'world ' = 'world ' COLLATE UTF8_BINARY_RTRIM AS rtrim;
default utf8_binary rtrim
------- ----------- -----
false false true