SELECT * FROM 表1 PIVOT XML(MAX(NULL)FOR 组员 IN(ANY))
SELECT SS, MAX(decode(RN, 1, ZY)), MAX(decode(RN, 2, ZY)), MAX(decode(RN, 3, ZY)) FROM (SELECT ROW_NUMBER() OVER(PARTITION BY SS ORDER BY SS) AS RN, ZY, SS FROM TEST) GROUP BY SS
SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY SS ORDER BY SS) AS RN, ZY, SS FROM TEST) PIVOT(MAX(ZY) FOR RN IN ('1' AS str1,'2' AS str2,'3' AS str3))
MAX(decode(RN, 1, ZY)),
MAX(decode(RN, 2, ZY)),
MAX(decode(RN, 3, ZY))
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY SS ORDER BY SS) AS RN, ZY, SS
FROM TEST)
GROUP BY SS
FROM TEST) PIVOT(MAX(ZY) FOR RN IN ('1' AS str1,'2' AS str2,'3' AS str3))