表行业类别的数据

查询与 010101 有关的所有上级tree node

with temp as
(
select hybm,hyms,sjhybm,hyjb from dmt_hydm where hybm = 010101
union all
select h.hybm,h.hyms,h.sjhybm,h.hyjb from dmt_hydm h,temp t where h.hybm=t.sjhybm
)
select * from temp order by hyjb

递归查询 树结构数据