1
(click on this box to dismiss)
CUBRID Hierarchical Queries
Suppose you have table representing a tree in the database. Something like:
TreeNode
Id, ParentId, Name
Is it possible to write a query in CUBRID to retrieve all the direct and indirect ancestors/predecessors of the specified tree node?
![[레벨:5]](http://www.cubrid.org/modules/point/icons/default/5.gif "Rank: 5/30, reputation score 263 (63% completed for the next level)"){kind=icon}
swanotets
1
1
Standard SQL supports this already by using recursive common table expressions (CTEs). CUBRID supports CTEs by default. You may want to check out this link for reference: http://en.wikipedia.org/wiki/Hierarchical_query.
Additionally there is a great tutorial on Hierarchical Queries in CUBRID (PDF).
질문시간 2년 전
viewed 769 times