title: sql query to get earliest date
body: <p>If I have a table with columns <code>id</code>, <code>name</code>, <code>score</code>, <code>date</code></p>
  
  <p>and I wanted to run a sql query to get the record where <code>id = 2</code> with the earliest date in the data set.  </p>
  
  <p>Can you do this within the query or do you need to loop after the fact?</p>
  
  <p>I want to get all of the fields of that record..</p>