title: group by records and then get last ascending sorted record from each group?
body: <p>I have a table:</p>
  
  <pre><code>| P_id | Month |  Year  |  Name  |
     624     09     2009    Test1
     600     10     2010    Test2
     624     10     2010    Test6
     600     09     2011    Test7
  </code></pre>
  
  <ol>
  <li><p>I want to order my table by <code>P_id</code> descending, <code>Year</code> ascending, then <code>Month</code> ascending</p></li>
  <li><p>Based on the order I want the last record for each <code>P_id</code>. </p></li>
  </ol>
  
  <p>After step 1 is run:</p>
  
  <pre><code>| P_id | Month |  Year  |  Name  |
    624     09      2009    Test1
    624     10      2010    Test6
    600     10      2010    Test2
    600     09      2011    Test7
  </code></pre>
  
  <p>Desired Output:</p>
  
  <pre><code>| P_id | Month |  Year  |  Name  |
     624     10     2010    Test6
     600     09     2011    Test7
  </code></pre>