title: SQL Server CE select row values with max date
body: <p>I'm using SQL Server CE that does not support sub-queries. And I have a table, that contains the result (value) of the check by dates. I need to select ID's with the last date, that was checked.</p>
  
  <p>I have these columns:</p>
  
  <pre><code>ID 
  ID_Tags    + 
  ID_Url     + 
  ID_Page    + 
  DateDownloaded 
  Value
  </code></pre>
  
  <p>The 3 columns marked with "+" together represent one checked instance, for which the value is needed.</p>
  
  <p>So I would like to select ID where ID_Tags, ID_Url and ID_Page are representing an unique combination and DateDownloaded is the last for this combination.</p>