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.