title: SQL latest changes
body: <p>I need the latest changes made to FIELD_NAME col. for example below, under col key_2, 3332P6; Field_Name 'Submission', was modified 3 times within my extract date. although not duplicate i need just the latest modification which is UNIQUE_RID 47271398. is that possible?</p>
  
  <p><a href="https://i.stack.imgur.com/hfLlc.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hfLlc.jpg" alt="enter image description here"></a></p>
  
  <pre><code>select Key_2,
         LEFT (REPLACE(KEY_2, '&amp;', ''), 4) PROJECT_CODE,
         (CASE WHEN LEN(REPLACE(KEY_2, '&amp;', ''))  &gt;4 THEN RIGHT(REPLACE(KEY_2, '&amp;', ''), 2)    ELSE ''
          END as PROJECT_PHASE,
  
          FIELD_NAME, AUDIT_OLD_VALUE, AUDIT_NEW_VALUE,
          UNIQUE_RID, AUDIT_DATE, AUDIT_TIME
  
   FROM TBADT_AUDIT_TRAIL 
   WHERE Key_1 like 'WKSCHART' AND
         Audit_Date between '2017-06-13' and '2017-06-16'
   ORDER BY Key_2, FIELD_NAME
  </code></pre>
  
  <p>I know that it works in VBA but I'm fairly new to SQL. Appreciate your help.</p>