求一个oracle 语句表TTYPEVALUESA1A2A3B1B2需要得到的结果TYPEVALUESA1，2，3B1，2请教该怎么写？[解决办法]SE
求一个oracle 语句
表 T
TYPE VALUES
A 1
A 2
A 3
B 1
B 2
需要得到的结果
TYPE VALUES
A 1，2，3
B 1，2
请教该怎么写？
[解决办法]
SELECT LTRIM(MAX(SYS_CONNECT_BY_PATH(TYPE, ', ')), ', ')
FROM (
SELECT TYPE, VALUES, ROW_NUMBER() OVER (PARTITION BY TYPE ORDER BY VALUES) AS CURR,
ROW_NUMBER() OVER (PARTITION BY TYPE ORDER BY VALUES) - 1 AS PREV
)
START WITH CURR = 1
CONNECT BY CURR = PRIOR PREV AND TYPE = PRIOR TYPE
GROUP BY TYPE