如何使用SQL根据列中的唯一值将多行组合成一行?

SELECT 
    "account ID",
    MAX(CASE WHEN rn = 1 THEN "question ID" END) AS "question ID (1)",
    MAX(CASE WHEN rn = 2 THEN "question ID" END) AS "question ID (2)",
    MAX(CASE WHEN rn = 3 THEN "question ID" END) AS "question ID (3)",
    MAX(CASE WHEN rn = 1 THEN "status" END) AS "status (1)",
    MAX(CASE WHEN rn = 2 THEN "status" END) AS "status (2)",
    MAX(CASE WHEN rn = 3 THEN "status" END) AS "status (3)"
FROM (
    SELECT "account ID", "question ID", "status", 
           ROW_NUMBER() OVER (PARTITION BY "account ID" ORDER BY "question ID") AS rn
    FROM your_table_name
) AS subquery
GROUP BY "account ID";

这将符合您的要求。