Help for this page

Select Code to Download


  1. or download this
    select * from nodes where parent_id=?
    
  2. or download this
    select * from nodes,children 
    where nodes.node_id=children.node_id
    and children.parent_id=?
    
  3. or download this
    select * from nodes where nodes.root_id=X.root_id
    and X.left<= nodes.right and nodes.left<=X.right