title: Deleting Duplicate Records in Oracle based on Maximum Date/Time
body: <p>i have the following sample data with duplicate information:</p>
  
  <pre><code>ID   Date                 Emp_ID    Name    Keep
  ---------------------------------------------------------
  1    17/11/2010 13:45:22  101       AB      *
  2    17/11/2010 13:44:10  101       AB
  3    17/11/2010 12:45:22  102       SF      *
  4    17/11/2010 12:44:10  102       SF
  5    17/11/2010 11:45:22  103       RD      *
  6    17/11/2010 11:44:10  103       RD        
  </code></pre>
  
  <p>Based on the above data set, how can I remove the duplicate Emp IDs and only keep the Emp IDs that have the maximum date/time specified?</p>
  
  <p>So based on the above, I would only see IDs: 1, 3 and 5.</p>
  
  <p>Thanks.</p>