title: SQL find only records that appear more than once
body: <p>I am trying to select only the records that appear more than once.</p>
  <p>Here is my table, I want to pull out records that have the same Column C.</p>
  <pre><code>A      B                C                   D
  1 | 29-005628 | 100 TIMS CREEK RD        | WD66
  2 | 29-005631 | 100 TIMS CREEK RD        | WT70
  3 | 29-005635 | 5300 HIDDEN MANOR CT     | WT89
  4 | 29-005638 | 600 LINDLEY CRESCENT AV  | WT30
  5 | 29-005639 | 100 TIMS CREEK RD        | WT89
  6 | 29-003238 | 501 PARK VIEW AV         | WT60
  7 | 29-009104 | 501 PARK VIEW AV         | WT80
  </code></pre>
  <p>Desired Output:</p>
  <pre><code>A       B              C                     D
  1 | 29-005628 | 100 TIMS CREEK RD        | WT66
  2 | 29-005631 | 100 TIMS CREEK RD        | WT70
  3 | 29-005639 | 100 TIMS CREEK RD        | WT89
  4 | 29-003238 | 501 PARK VIEW AV         | WT60
  5 | 29-009104 | 501 PARK VIEW AV         | WT80
  </code></pre>
  <p>Any help with a query would be appreciated!</p>