Prev: Cast Numeric data type gain during Sum
Next: "pivoting" when the column selectors are inequalities?
From: gv on 26 Jul 2010 10:57
Hi all,

Using the "Nested set model" how do you find the level 1 parent node in the
highest point of the tree no matter how deep the child node is?

thanks CELKO for the several post on nested set model..

thanks
gv


From: --CELKO-- on 26 Jul 2010 13:30
>> find the level 1 parent node in the highest point of the tree no matter how deep the child node is? <<

That is the root;

SELECT node_id
FROM Tree
WHERE lft =1;

This is probably not the question you were trying to ask.
 | 
Pages: 1
Prev: Cast Numeric data type gain during Sum
Next: "pivoting" when the column selectors are inequalities?