Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
NULLIF
On this page
The NULLIF() function returns NULL if the arguments are equal, otherwise the first argument.
Syntax
NULLIF (val1, val2)Arguments
-
Any SQL objects.
Return Type
The return value has the same type as the first argument, or NULL.
Examples
SELECT NULLIF(1,2);
+-------------+
| NULLIF(1,2) |
+-------------+
| 1 |
+-------------+SELECT NULLIF(2,2);
+-------------+
| NULLIF(2,2) |
+-------------+
| NULL |
+-------------+SELECT NULLIF(NULL, NULL);
+--------------------+
| NULLIF(NULL, NULL) |
+--------------------+
| NULL |
+--------------------+SELECT NULL = NULL;
+-------------+
| NULL = NULL |
+-------------+
| NULL |
+-------------+Last modified: