title: Query to return 1 instance of a record with duplicates
body: <p>INFO: I am working with Microsoft SQL.<br>
  Ok the title is confusing but here is an example of the table I'm working with:</p>
  
  <pre><code>ID    Value    Signal    Read    Firmware    Date           Time
  5     123      656       444       217       3/30/2009     11:00:00 AM
  5     123      421       333       217       3/30/2009     04:00:00 PM
  5     123      111       666       217       3/30/2009     05:00:00 PM
  9     321      231       551       216       3/30/2009     09:00:00 AM
  9     321      599       887       216       3/30/2009     09:30:00 AM
  </code></pre>
  
  <p>So I want the Query to return:</p>
  
  <pre><code>ID    Value    Signal    Read    Firmware    Date           Time
  5     123      111       666       217       3/30/2009     05:00:00 PM
  9     321      599       887       216       3/30/2009     09:30:00 AM
  </code></pre>
  
  <p>I have tried:</p>
  
  <pre><code>SELECT DISTINCT ID, Value, Signal, Read, Firmware, Date, Time FROM ....
  </code></pre>
  
  <p>But this returns all of the results. I have also tried SELECT TOP 1... but I couldn't get that to work. I know this is simple, but I'm confused on how to get this to display only 1 single unique row.<br>
  Thanks for the help.</p>