sql - 逐行显示

Question

使用 SQL Server 2000

表1

ID Value

101 100
102 200
103 500

表格中只有 3 行。我想按行查看

预期输出

101 102 103
100 200 500

如何针对上述条件进行选择查询。

需要查询帮助

Answer 1

如果您确实知道 ID 列中有哪些值，您可以使用这样的查询:

SELECT
    MAX(id_101) AS id_101,
    MAX(id_102) AS id_102,
    MAX(id_103) AS id_103
FROM (
SELECT
    1 AS aux,
    CASE WHEN ID = 101 THEN val ELSE null END AS id_101,
    CASE WHEN ID = 102 THEN val ELSE null END AS id_102,
    CASE WHEN ID = 103 THEN val ELSE null END AS id_103
FROM table1
) AS t(aux, id_101, id_102, id_103)
GROUP BY t.aux;