title: Selecting most recent date in SQL
body: <p>I have a table with over 150k rows and about 40 columns. There are a lot of duplicates, most of the rows only differ by a date. I want to keep the rows with the latest date (some of the dates are in the future), where all the other columns are the same. 
  I'm using Access database. </p>
  
  <p>Roughly, the table looks like this:</p>
  
  <pre><code>Supplier code, Contract number, Incoterms, Currency, Price, First day of validity, Last day of validity
  --------------------------
  47650          2806751M         DDA        EUR       0.01   01/03/2010             31/12/2012
  47650          2806751M         DDA        EUR       0.02   01/01/2013             31/12/2014
  47650          2806751M         DDA        EUR       0.03   01/01/2015             31/12/2016
  47650          2806751M         DDA        EUR       0.04   01/01/2017             31/12/2019
  
  </code></pre>
  
  <p>All these columns contain almost the same data, but the period of validity of the contract is the important variable, since it determines the price. That's why I want to keep the row that contains the latest date. </p>