使用sql server在单行中显示表的对角线行元素。

CREATE TABLE #DiagonalTable (id INT PRIMARY KEY, value VARCHAR(50));

INSERT INTO #DiagonalTable (id, value)
VALUES (1, 'A'), (2, 'B'), (3, 'C'), (4, 'D');

SELECT 
    (SELECT value FROM #DiagonalTable WHERE id = 1) AS [1],
    (SELECT value FROM #DiagonalTable WHERE id = 2) AS [2],
    (SELECT value FROM #DiagonalTable WHERE id = 3) AS [3],
    (SELECT value FROM #DiagonalTable WHERE id = 4) AS [4];

DROP TABLE #DiagonalTable;