title: MySQL - Filtering table based on most current dates
body: <p>My first post on stackoverflow please be gentle! <br /><br />
  I have a MySQL (5.5.24) Database (WAMP Setup) with a table with records like this</p>
  
  <pre><code>Person_ID     R_Date    
  
  137           2013-01-01    
  137           2013-02-01
  137           2013-03-15  
  168           2013-01-01
  168           2013-02-01
  168           2013-03-21
  172           2013-01-01
  172           2013-02-01
  172           2013-03-27
  </code></pre>
  
  <p>However I would like to just have 1 record for each Person_ID using the most recent/current R_Date.   <br /><br />
  So the results would look like this:</p>
  
  <pre><code>Person_ID    R_Date
  
  137          2013-03-15
  168          2013-03-21
  172          2013-02-27
  </code></pre>
  
  <p>I have had difficulty searching for answers as I'm not sure of the terminology, it is possibly something really simple. <br /> <br />It is possible to get this result using PHP While loops combined with multiple MySQL queries but I'm after a pure MySQL solution if it's possible.
  Maybe the results I am after are achievable with subqueries? <br /><br />Thanks</p>