oracle£ºµÝ¹éͳ¼Æ£¨¶à×ֶΣ©

Ô´Êý¾Ý±í

ID	NAME	PID	VALUE1	VALUE2	VALUE3
1	Ò»	0	1	2	3
2	¶þ	1	10	20	30
3	Èý	2	100	200	300

sqlÓï¾ä

select sum(t.value1) || ',' || sum(t.value2) || ',' || sum(t.value3)
from test t
connect by prior t.id = t.pid
start with t.id = 1

½á¹û

sum(t.value1) || ',' || sum(t.value2) || ',' || sum(t.value3)

111,222,333