select * from node_definition start with super_id ='Q2' connect by super_id = prior pkid
select * from node_definition start with super_id ='Q2' connect by prior pkid = super_id
这2个等效 向下查询
select * from node_definition start with super_id ='Q2' connect by pkid = prior super_id
select * from node_definition start with super_id ='Q2' connect by prior super_id = pkid
这2个等效 向上查询
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11813230/viewspace-620555/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
