title: Self Join and Iterative SQL
body: <p>Sample  Table </p>
  
  <pre><code>Emp Id Emp Name Manager Id
  1001   arun     1004
  1002   Bharath  1004
  1003   Chitra   1004
  1004   Devi     1005
  1005   Eli      1006
  1006   Fatima   1007
  1007   Ganesh   1008
  </code></pre>
  
  <p>when i select manager id 1004 it should display three names arun,bharath,chitra and if i select 1005 it should display devi,arun,bharath,chitra </p>
  
  <p>FYI - ManagerId is same as the EMPId.</p>
  
  <p>How can I prepare the sql with out using functions?</p>