title: Select most recent rows that match a condition in SQLite
body: <p>Let's say I have a table:</p>
  
  <pre><code>Name, status, timestamp
  </code></pre>
  
  <p>And I want to select the rows that match status='active' but only those that have the most recent timestamp for each of them.  So if there were rows like this:</p>
  
  <pre><code>Bob, active, 5/10/2010
  Bob, active, 6/12/2010
  Ann, inactive, 6/12/2000
  Ann, active, 9/3/2009
  Ann, active, 9/25/2010
  </code></pre>
  
  <p>I'd want it to return:</p>
  
  <pre><code>Bob, active, 6/12/2010
  Ann, active, 9/25/2010
  </code></pre>
  
  <p>How can I do this?  I'm using SQLite, if it matters.</p>
  
  <p>Thank you.</p>