title: Transpose of a table
body: <p>In my database I have a table, which has a column A and the respective values are:</p>
  
  <pre><code>A
  --
  1
  2
  3
  4
  5
  </code></pre>
  
  <p>Is there any way that I can convert the table into</p>
  
  <pre><code>A|1|2|3|4|5|
  </code></pre>
  
  <p>I tried using the <code>PIVOT</code> keyword but I'm not able to get the result.</p>