title: Selecting rows limited to the most recent date
body: <p>I am a SQL novice, trying to figure out a way to pare down rows that basically gives me only one name per row, with the criteria being the latest "Encounter Date". I want to go from this:</p>
  
  <pre><code>    Measure_ID   Name   User    Encounter Date  Numerator
      NQF-0101      A      1           4/10/2015        0
      NQF-0101      A      1           4/11/2015        1
      NQF-0101      B      2           4/12/2015        1
      NQF-0101      B      2           4/13/2015        0
      NQF-0101      C      3           4/14/2015        1
      NQF-0101      C      3           4/15/2015        1
      NQF-0101      C      3           4/16/2015        1
  </code></pre>
  
  <p>To this:</p>
  
  <pre><code>   Measure_ID  Name  User    Encounter Date   Numerator
     NQF-0101     A     1           4/11/2015           1
     NQF-0101     B     2           4/13/2015           0
     NQF-0101     C     3           4/16/2015           1
  </code></pre>
  
  <p>Any thoughts on the type of SQL query I can run to make this happen? Thank you!</p>