22,207
社区成员
发帖
与我相关
我的任务
分享
with t1(flever, fINDEX, fitem) as
(
select '0', 1, 'a' union all
select '1', 2, 'b' union all
select '1.1', 3, 'c' union all
select '1.2', 4, 'd' union all
select '1.2.1', 5, 'c'
)
select b.fitem, a.fitem
from t1 a
inner join
t1 b
on (a.flever like b.flever+'.%' and a.flever not like b.flever+'.%.%') or (a.flever='1' and b.flever='0')