title: DB2 query - selecting specific duplicated records
body: <p>I am pretty new to dealing with DB2 - on an IBM AS400.</p>
  
  <p>I ran the following query :</p>
  
  <pre><code>SELECT *                                                         
  FROM mytable
  WHERE ID = 1963003909     
  </code></pre>
  
  <p>This is the results of the query:</p>
  
  <pre><code>     ID    WK END DT  VRSN    AMT  
   -----------  ----------  ------  ------------  
    1963003909  2012-03-24       1          0.00  
    1963003909  2012-03-31       1          0.00  
    1963003909  2012-04-07       1          0.00  
    1963003909  2012-04-14       1          0.00  
    1963003909  2012-04-21       1          0.00  
    1963003909  2012-04-28       1          0.00  
    1963003909  2012-05-05       1          0.00  
    1963003909  2012-05-12       1          0.00  
    1963003909  2012-05-19       1          0.00  
    1963003909  2012-05-26       1          0.00  
    1963003909  2012-06-02       1          0.00  
    1963003909  2012-06-09       1          0.00  
    1963003909  2012-06-16       1          0.00  
    1963003909  2012-06-23       1          0.00  
    1963003909  2012-06-30       1          0.00  
    1963003909  2012-07-07       1          0.00  
    1963003909  2012-07-14       1          0.00  
    1963003909  2012-07-21       1          0.00  
    1963003909  2012-07-28       1          0.00  
    1963003909  2012-07-28       2        320.00  
  </code></pre>
  
  <p>I want to be able to modify the query to select only the records with the maximum in the VRSN column to be able to put the information into a report.</p>
  
  <p>I have tried to read other examples from this site, but couldn't find anything that wasn't showing how to delete duplicate records from the table.</p>
  
  <p>Thanks</p>