简单的方法来转置每6行为columns1，2，3等在Sql？

SELECT 
    (ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1) / 6 AS GroupId,
    *
FROM 
    your_table;

SELECT 
    MAX(CASE WHEN GroupId = 0 THEN column_value END) AS column1,
    MAX(CASE WHEN GroupId = 1 THEN column_value END) AS column2,
    MAX(CASE WHEN GroupId = 2 THEN column_value END) AS column3,
    ...
FROM 
    (
    SELECT 
        (ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1) / 6 AS GroupId,
        column_value
    FROM 
        your_table
    ) AS subquery
GROUP BY 
    GroupId;