title: SQL Query to roll down the manager hierarchy
body: <p>The scenario is :-
  Joyce is a MGR, reporting to Pam. Greg is a MGR reporting to Joyce, thus rolling up to Pam. </p>
  
  <p>So for a very high level person,you will see all the reportees directly or indirectly related to him with the query.</p>
  
  <p>Table with the information TABLE_MGR :-</p>
  
  <pre><code>Employee    MGR
  
  Joyce       PAM
  GREG        JOYCE
  </code></pre>
  
  <p>So the desired output will be as </p>
  
  <pre><code> Employee    MGR
  
  Joyce       PAM
  GREG        PAM
  </code></pre>
  
  <p>How can this be achieved ?</p>