title: Select the first instance of a record
body: <p>I have a table, <code>myTable</code> that has two fields in it <code>ID</code> and <code>patientID</code>.  The same patientID can be in the table more than once with a different ID.  How can I make sure that I get only <code>ONE</code> instance of every <code>patientID</code>.?</p>
  
  <p>EDIT: I know this isn't perfect design, but I need to get some info out of the database and today and then fix it later.</p>