title: Count all duplicates of each value
body: <p>I would like a SQL query for MS Jet 4.0 (MSSql?) to get a count of all the duplicates of each number in a database.</p>
  
  <p>The fields are: <code>id</code> (autonum), <code>number</code> (text)  </p>
  
  <p>I have a database with a lot of numbers.</p>
  
  <p>Each number should be returned in numerical order, without duplicates, with a count of all duplicates.</p>
  
  <p>Number-fields containing 1, 2, 2, 3, 1, 4, 2 should return:</p>
  
  <pre><code>1, 2  
  2, 3  
  3, 1  
  4, 1  
  </code></pre>