title: Get record with min value of a group
body: <p>I'm trying to do the opposite of this <a href="https://stackoverflow.com/questions/12102200/get-records-with-max-value-for-each-group-of-grouped-sql-results">question</a></p>
  
  <p>I need to get the minimum value out of a grouped record, so, taking the same information from the linked question, from</p>
  
  <pre><code>ID | Person | Group | Age
  ---
  1  | Bob    | 1     | 32  
  2  | Jill   | 1     | 34  
  3  | Shawn  | 1     | 42  
  4  | Jake   | 2     | 29  
  5  | Tom    | 2     | 28  
  6  | Paul   | 2     | 36  
  7  | Laura  | 2     | 39  
  8  | Julie  | 2     | 28  
  </code></pre>
  
  <p>Desired result set:</p>
  
  <pre><code>1  | Bob    | 1     | 32    
  5  | Tom    | 2     | 28  
  </code></pre>
  
  <p>I tried by joining the table on herself with opposite condition (&lt; instead of >) but it's not working.</p>
  
  <p>Duplicates are not allowed, if two persons have the same age, the one with the lowest ID has to be returned. </p>