title: How to show Rows of Duplicate Entries?
body: <p>I want to get only the rows that have duplicate entries in column <code>newcons</code>. In the result, I want to show the whole row with <code>recno</code> and <code>oldcons</code>, and against it <code>newCons</code> should appear. What SQL query can I use to do this?</p>
  
  <p>Here is my Table:</p>
  
  <pre><code>RecNo OldB  OldCons    NewCons
  1   01      0145501     0008000
  2   01      0253801     0107400
  3   01      0271200     0000500
  4   01      0271201     0012000
  5   01      0271202     0000200
  6   01      0271300     0000800
  7   01      0271301     0001100
  8   01      0271302     0002000
  9   01      0271303     0001000
  10  01      0271304     0001000
  </code></pre>
  
  <p>This result should appear: </p>
  
  <pre><code>RecNo   OldBch  OldSdiv OldCons NewSdiv NewCons
  9       01      14433   0271303 14433   0001000
  10      01      14433   0271304 14433   0001000
  </code></pre>
  
  <p>How can I do this ?</p>