如何将SQL数据顺序从行更改为列？

SELECT
    column1,
    MAX(CASE WHEN column2 = 'value1' THEN column3 END) AS value1,
    MAX(CASE WHEN column2 = 'value2' THEN column3 END) AS value2,
    MAX(CASE WHEN column2 = 'value3' THEN column3 END) AS value3
FROM
    table_name
GROUP BY
    column1;

SELECT
    column1,
    value1,
    value2,
    value3
FROM
    table_name
PIVOT (
    MAX(column3)
    FOR column2 IN ('value1', 'value2', 'value3')
);

SELECT
    column1,
    value1,
    value2,
    value3
FROM
    table_name
UNPIVOT (
    column3 FOR column2 IN ('value1' AS 'value1', 'value2' AS 'value2', 'value3' AS 'value3')
);

SELECT
    column1,
    value1,
    value2,
    value3
FROM
    CROSSTAB(
        'SELECT column1, column2, column3 FROM table_name',
        'SELECT DISTINCT column2 FROM table_name ORDER BY 1'
    ) AS ct (column1 text, value1 numeric, value2 numeric, value3 numeric);