PIVOT performs an aggregation and, therefore, merges possible multiple rows into a single row in the output.

• PIVOT会执行一次聚合,从而将多个可能的行合并为输出中的单个行。