title: SQLITE select unique rows
body: <p>I have a table where rows appear to be "duplicates" but they are actually not (they have different date). </p>
  
  <p>Suppose each record has a column A that is supposed to be unique. However due to this column A could or could not appear again later with updated information (with column A unchanged), it is no longer unique even when it should be. </p>
  
  <p>Therefore I want the table with latest information only. Currently this table contains 500k entries, however the "true" number of unique entries is less than half of it. </p>
  
  <p>I have tried </p>
  
  <pre><code>SELECT *
    FROM TABLE
      WHERE A = A  
      AND Date = (SELECT MAX(Date) from TABLE)
      ORDER BY DATE 
  </code></pre>
  
  <p>However this only returns 2 results. How do I achieve that?</p>