oracle sql查询:获取表中具有相同ID的所有条目作为单独的列

SELECT ID,
       MAX(CASE WHEN rn = 1 THEN ITEM END) AS ITEM1,
       MAX(CASE WHEN rn = 2 THEN ITEM END) AS ITEM2,
       MAX(CASE WHEN rn = 3 THEN ITEM END) AS ITEM3,
       -- 继续添加更多的列...
FROM (
    SELECT ID,
           ITEM,
           ROW_NUMBER() OVER (PARTITION BY ID ORDER BY ITEM) AS rn
    FROM your_table
)
GROUP BY ID;