title: Select Rows As Column in SELECT
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1578500/how-to-select-columns-as-rows">how to select columns as rows?</a>  </p>
  </blockquote>
  
  
  
  <p>I have a table with ID's, like</p>
  
  <pre><code>Table
  -------
    1
    2
    3
    4
    5
    and so on
  </code></pre>
  
  <p>I have this query,</p>
  
  <p>SELECT A,B,<strong>Here I need To SELECT the Id's as Column</strong>,  FROM MyTable</p>
  
  <p>So the Result of this will be,</p>
  
  <pre><code>  A  B  1  2  3  4  5  6  7 and so on
    -----------------------------------
  </code></pre>