建一张表
create table user_role(
id VARCHAR(40),
parentid VARCHAR(40)
)
显示是这样的
查询根节点固定语法
SELECT PARENTID
FROM user_role
WHERE connect_by_isleaf=1
START WITH ID =‘0’
CONNECT BY PRIOR PARENTID = ID;
下面是结果
建一张表
create table user_role(
id VARCHAR(40),
parentid VARCHAR(40)
)
显示是这样的
查询根节点固定语法
SELECT PARENTID
FROM user_role
WHERE connect_by_isleaf=1
START WITH ID =‘0’
CONNECT BY PRIOR PARENTID = ID;
下面是结果