title: show duplicates from each group in temporary table using mysql
body: <p>Can some one help me with a mysql query to show duplicates from each group in temporary table using mysql</p>
  
  <p>sqlfiddle
  <a href="http://sqlfiddle.com/#!2/d8c9c/17" rel="nofollow">http://sqlfiddle.com/#!2/d8c9c/17</a></p>
  
  <p>Table</p>
  
  <pre><code>TOWN    ID1
  town1   1
  town1   1
  town1   4
  town2   1
  town2   5
  town2   8
  town3   1
  town3   3
  town3   3
  </code></pre>
  
  <p>Required result</p>
  
  <pre><code>TOWN    ID1
  town1   1
  town1   1
  town3   3
  town3   3
  </code></pre>
  
  <p>I have tried SELECT *  FROM Table1 group by TOWN,ID1
  but this removes duplicates and also shows non-duplicate records</p>