写一段sqlserver行转列的sql语句

SELECT 列1, 列2, 列3,
MAX(CASE WHEN 列4 = 'A' THEN 列5 END) AS A,
MAX(CASE WHEN 列4 = 'B' THEN 列5 END) AS B,
MAX(CASE WHEN 列4 = 'C' THEN 列5 END) AS C
FROM 表
GROUP BY 列1, 列2, 列3;