title: How to get column of table with a self-referencing foreign key?
body: <p>I have a table structure shown below:</p>
  
  <pre><code>Id      Name    Sal     ManagerId
  1       a       5000       2
  2       b       7000       3
  3       c       6000       1
  </code></pre>
  
  <p>I need output like this</p>
  
  <pre><code>Id     Name    Sal     Manager
  1      a       5000      b
  2      b       7000      c
  3      c       6000      a
  </code></pre>
  
  <p>How can i do that?</p>