title: how to repeat each row twice
body: <p>I have a requirement for a report and I would like my sql query to repeat each row twice.</p>
  
  <p>Example :</p>
  
  <pre><code>  **Table 1**
     Id   Name
     1     Ab
     2     Cd
     3     Ef
  </code></pre>
  
  <p>I want to write a query which outputs the following :</p>
  
  <pre><code>  1   Ab
    1   Ab
    2   Cd
    2   Cd
    3   Ef
    3   Ef
  </code></pre>
  
  <p>Is there a way I can do it ?</p>
  
  <p>I cannot think of anything except using <code>union</code> </p>
  
  <pre><code>Select Id, name from Table1 union select Id, name from Table1
  </code></pre>