title: Why does select statement return distinct values from a table where there are duplicate results?
body: <p>I am inserting value in a table like this (SQL Server)</p>
  
  <pre><code>create table #t1 (id int)
  
  insert into #t1(id)
     select 1 union
     select 2 union
     select 2 union
     select 1 
  
  select * from #t1
  </code></pre>
  
  <p>But it gives me this data:</p>
  
  <pre><code>  id
  -----
    1
    2
  </code></pre>
  
  <p>While I need data like:</p>
  
  <pre><code>  id
  ----
    1
    2
    2
    1
  </code></pre>