title: Get most recent row for given ID
body: <p>In the table below, how do I get just the <strong>most recent row</strong> with <code>id=1</code> based on the <code>signin</code> column, and not all 3 rows?</p>
  <pre><code>+----+---------------------+---------+
  | id | signin              | signout |
  +----+---------------------+---------+
  |  1 | 2011-12-12 09:27:24 | NULL    |
  |  1 | 2011-12-13 09:27:31 | NULL    |
  |  1 | 2011-12-14 09:27:34 | NULL    |
  |  2 | 2011-12-14 09:28:21 | NULL    |
  +----+---------------------+---------+
  </code></pre>