title: Find earliest and latest dates of specified records from a table using SQL
body: <p>I have a table (in MS SQL 2005) with a selection of dates. I want to be able to apply a WHERE statement to return a group of them and then return which date is the earliest from one column and which one is the latest from another column. Here is an example table:</p>
  
  <pre><code>ID StartDate  EndDate    Person
  1  01/03/2010 03/03/2010 Paul
  2  12/05/2010 22/05/2010 Steve
  3  04/03/2101 08/03/2010 Paul
  </code></pre>
  
  <p>So I want to return all the records where Person = 'Paul'. But return something like (earliest ) StartDate = 01/03/2010 (from record ID 1) and (latest) EndDate = 08/03/2010 (from record ID 3).</p>
  
  <p>Thanks in advance</p>