When aggregate functions are used with PIVOT, the presence of any null values in the value column are not considered when computing an aggregation.

• 如果聚合函数与PIVOT一起使用,则计算聚合时将不考虑出现在值列中的任何空值。