All values that are not null of value_expression, including duplicates, are included in the computation.