title: How do I write an SQL query to identify duplicate values in a specific field?
body: <p>This is the table I'm working with:</p>
  
  <p><img src="https://i.stack.imgur.com/QZU7x.png" alt="The table">
  <BR><BR>
  I would like to identify only the ReviewIDs that have duplicate deduction IDs for different parameters.</p>
  
  <p>For example, in the image above, ReviewID 114 has two different parameter IDs, but both records have the same deduction ID.</p>
  
  <p>For my purposes, this record (ReviewID 114) has an error.  There should not be two or more unique parameter IDs that have the same deduction ID for a single ReviewID.</p>
  
  <p>I would like write a query to identify these types of records, but my SQL skills aren't there yet.  Help?</p>
  
  <p>Thanks!</p>
  
  <p><strong>Update 1:</strong> I'm using TSQL (SQL Server 2008) if that helps<BR>
  <strong>Update 2:</strong> The output that I'm looking for would be the same as the image above, minus any records that do not match the criteria I've described.</p>
  
  <p>Cheers!</p>