T-SQL - 如何交换行和列

-- 创建一个名为 "employees" 的表
CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT,
    department VARCHAR(50)
);

-- 插入示例数据
INSERT INTO employees (id, name, age, department)
VALUES (1, 'Alice', 25, 'HR'),
       (2, 'Bob', 30, 'IT'),
       (3, 'Carol', 28, 'Finance');

-- 交换行和列
SELECT * FROM (
    SELECT id, name, age, department
    FROM employees
) AS SourceTable
PIVOT (
    MAX(name) FOR department IN ([HR], [IT], [Finance])
) AS PivotTable;