title: How can SQL create duplicate records?
body: <p>I was having a look at this question: <a href="https://stackoverflow.com/questions/10068099/getting-random-value-from-a-sqlite-table">Getting random value from a SQLite table</a> and it got me wondering if one can duplicate records using SQL. More specifically, is there a construct that allows to transform these records:</p>
  
  <pre><code>id| name| count
  ---------------
   1| Anne|     3
   2|  Joe|     2
  </code></pre>
  
  <p>into:</p>
  
  <pre><code>id| name
  --------
   1| Anne
   1| Anne
   1| Anne
   2|  Joe
   2|  Joe
  </code></pre>
  
  <p>where the count of <code>Anne</code> and <code>Joe</code> records in the latter matches the corresponding <code>count</code> value in the former set of records.</p>
  
  <p>Can it be done with SQL? If so, how?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>Lucero asks what SQL dialect; any really, but ideally the most agnostic approach would be the best.</p>
  
  <p><strong>ANOTHER EDIT:</strong></p>
  
  <p>Can it be done within a single SQL statement in say sqlite?</p>