title: SQL how to append rows to columns?
body: <p>I have a table with many rows and two columns. So for instance, my table would look like this:</p>
  
  <pre><code>ID   Name
  
  1     Bob
  
  2    Jerry
  
  3    Tom
  
  4    John
  </code></pre>
  
  <p>Ultimately what I want though is for the table to look like this:</p>
  
  <pre><code>ID Name ID Name ID Name ID Name
  
  1  Bob   2 Jerry 3 Tom 4 John
  </code></pre>
  
  <p>How would I do this in SQL? </p>
  
  <p>Thanks</p>