Returns NULL if expr1 equals expr2, otherwise returns expr1.
Syntax
T nullif(T <expr1>, T <expr2>)Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
expr1 | Yes | Any | The value to return if the two arguments are not equal. T can be any data type supported by MaxCompute. |
expr2 | Yes | Any | The value to compare against expr1. Must be the same type as expr1. |
Return value
Returns expr1 if expr1 != expr2, or null if expr1 = expr2.
Examples
-- Returns 2 (values differ, expr1 is returned)
select nullif(2, 3);
-- Returns null (values are equal)
select nullif(2, 2);
-- Returns 3 (null is not equal to 3, so expr1 is returned)
select nullif(3, null);Related functions
该文章对您有帮助吗？