title: SQL query to find duplicates
body: <p>I am trying to write a query in SQL server to find out if there are any multiple rows for each hash value.<br> 
  I need all filenames where the hash value has duplicates.</p>
  
  <p>The result should be (based on my example below)</p>
  
  <pre><code>003B4C68BC143B0290E04432A3A96092    File0003.jpg
  003B4C68BC143B0290E04432A3A96092    File0004.jpg
  003B4C68BC143B0290E04432A3A96092    File0005.jpg
  </code></pre>
  
  <p>Please let me know.</p>
  
  <p>Here is the table structure</p>
  
  <pre><code>File table
  -----------------------------------------
  hash          FileName
  ---------------------------------------
  000341A486F5492877D588BED0806650    File0001.jpg
  00363EF2ECEEA32F10176EB64A50283F    File0002.jpg
  003B4C68BC143B0290E04432A3A96092    File0003.jpg
  003B4C68BC143B0290E04432A3A96092    File0004.jpg
  003B4C68BC143B0290E04432A3A96092    File0005.jpg
  </code></pre>