title: How to remove a duplicate row in SQL with an older date field
body: <p>I have two rows in my table which are exact duplicates with the exception of a date field. I want to find these records and delete the older record by hopefully comparing the dates.</p>
  
  <p>For example I have the following data</p>
  
  <pre><code>    ctrc_num | Ctrc_name   | some_date
     ---------------------------------------
          12345 | John R      | 2011-01-12
          12345 | John R      | 2012-01-12
          56789 | Sam S       | 2011-01-12
          56789 | Sam S       | 2012-01-12
  </code></pre>
  
  <p>Now the idea is to find duplicates with a different 'some_date' field and delete the older records. The final output should look something like this. </p>
  
  <pre><code>      ctrc_num | Ctrc_name   | some_date
     ---------------------------------------
          12345 | John R      | 2012-01-12
          56789 | Sam S       | 2012-01-12
  </code></pre>
  
  <p>Also note that my table does not have a primary key, it was originally created this way, not sure why, and it has to fit inside a stored procedure.  </p>