title: SQL query to return only 1 record per group ID
body: <p>I'm looking for a way to handle the following scenario. I have a database table that I need to return only one record for each "group id" that is contained within the table, furthermore the record that is selected within each group should be the oldest person in the household.</p>
  
  <pre><code>ID   Group ID   Name               Age
  1   134        John Bowers        37
  2   134        Kerri Bowers       33
  3   135        John Bowers        44
  4   135        Shannon Bowers     42
  </code></pre>
  
  <p>So in the sample data provided above I would need ID 1 and 3 returned, as they are the oldest people within each group id.</p>
  
  <p>This is being queried against a SQL Server 2005 database.</p>