找出层次超过1的这递归层数据，求sql
SELECT A.wf_id,a.parentid,level,sys_connect_by_path(A.wf_id,'/') path
FROM a
START WITH A.PARENTID IS NULL
CONNECT BY PRIOR A.WF_ID = A.PARENTID
SZ_120604161301_30001/SZ_120604161301_3000
SZ_120606095746_root1/SZ_120606095746_root
SZ_120606145252_30001/SZ_120606145252_3000
SZ_120606150143_30001/SZ_120606150143_3000
SZ_120606182414_root1/SZ_120606182414_root
SZ_120607170535_30001/SZ_120607170535_3000
SZ_120608102517_30001/SZ_120608102517_3000
SZ_120611172040_30001/SZ_120611172040_3000
SZ_120611174615_30001/SZ_120611174615_3000
SZ_120615105928_30001/SZ_120615105928_3000
SZ_120617174458_30001/SZ_120617174458_3000
SZ_120617174639_3000SZ_120617174458_30002/SZ_120617174458_3000/SZ_120617174639_3000
SZ_120617174932_3000SZ_120617174639_30003/SZ_120617174458_3000/SZ_120617174639_3000/SZ_120617174932_3000
我想要的数据是：
SZ_120617174458_30001/SZ_120617174458_3000
SZ_120617174639_3000SZ_120617174458_30002/SZ_120617174458_3000/SZ_120617174639_3000
SZ_120617174932_3000SZ_120617174639_30003/SZ_120617174458_3000/SZ_120617174639_3000/SZ_120617174932_3000
请问高手们这个sql该咋写？
[解决办法]
那就在2楼给的语句上再包一层。先判断level，如果大于1了，再重新拼接串
找到层次超过1的这递归层数据，求sql
找出层次超过1的这递归层数据，求sqlSELECT A.wf_id,a.parentid,level,sys_connect_by_path(A.wf_id,/) p