NULLIF

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: February 24, 2023

Was this article helpful?