title: How to select a value on the first row and last on SQL?
body: <p>I have a table like this: </p>
  
  <pre><code>ID | persid | value1  | value2
  ---+--------+---------+---------
  1  | A      | string1 | string2
  2  | A      | string3 | string4
  3  | A      | string5 | string6
  </code></pre>
  
  <p>I need to return something like this using <code>GROUP BY</code>:</p>
  
  <pre><code>Field1 | field2  |  field3
  -------+---------+----------
  A      | string1 |  string6 
  </code></pre>
  
  <p>I'm using SQL server 2008,
  Is this possible?</p>