title: Select Min Date in SQL
body: <p>I have a table below. I want to select Min Date and the corresponding ticket status. I tried but is showing me two or more plate numbers. just want the mindate. thanks</p>
  
  <pre><code>Date       PlateNo     TickeStatus
  01-15-12       A        Open
  01-23-12       c        Open
  01-17-12       A        Close
  02-23-12       c        Open
  02-15-12       A        Open
  03-23-12       c        Open
  03-15-12       A        Close
  03-28-12       c        Close
  04-15-12       A        Open
  04-23-12       c        Close
  </code></pre>