select xfjid,substr(max(sys_connect_by_path(jsbmmc,';')),2)
from (
select xfjid,jsbmmc,row_number() over(partition by xfjid order by xfjid) cs from xf_ywbl where fsfs='1' and xfjid = '41642'
) start with cs=1 connect by cs = prior cs+1
and xfjid = prior xfjid
group by xfjid
类似这个样子？？
内容全部来源于网络收集，如有侵权，请联系网站删除！