基础数据
一、向上查询父级数据
select * from location
start with id = '163' connect by prior pid = id order by id asc;
二、向下查询子级数据
select * from location
start with id = '1' connect by pid = prior id order by id asc;
基础数据
一、向上查询父级数据
select * from location
start with id = '163' connect by prior pid = id order by id asc;
二、向下查询子级数据
select * from location
start with id = '1' connect by pid = prior id order by id asc;