SELECT * FROM table_name PIVOT (MAX(column_name) FOR column_name2 IN (list_of_values) ORDER BY column_name3) AS PivotTableName;
sql 将行转列 并分组排序
最新推荐文章于 2023-06-09 14:41:27 发布
SELECT * FROM table_name PIVOT (MAX(column_name) FOR column_name2 IN (list_of_values) ORDER BY column_name3) AS PivotTableName;