with temp(no,roes,start,end) as
(select no+roes,roes,start,end from t_node
union all
select no+roes as no,roes,start,end
from temp
where no+roes<end
)
select * from temp;
with temp(no,roes,start,end) as
(select no,roes,start,end from t_node
union all
select no+roes as no,roes,start,end
from temp
where no+roes<end
)
select * from temp;