Null Value Operations
Generally, if a NULL value is one of the arguments of a function/operator, the result would be NULL, with the following exceptions:
-
With comparison operators, the NULL value indicates the minimum value; with logical operators, the NULL value indicates false value.
-
If used as one of the arguments of aggregate functions such as
sum
/avg
/med
, NULL values are ignored.