title: SQL Tree Structure
body: <p>I am new to this topic (i.e tree structure) in SQL. I have gone through different sources but still not clear.</p>
  
  <p>Here in my case, I have a table which I have attached herewith.</p>
  
  <p><a href="https://i.stack.imgur.com/jjhKX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jjhKX.png" alt="enter image description here"></a></p>
  
  <p>Now here first, I have to retrieve a Full Tree for “OFFICE”.</p>
  
  <p>Also i have to find all the leaf nodes (those with no Children) in the attached hierarchical data.</p>
  
  <p>Please provide the answers with detail explanation. 
  Thanks in advance.</p>