title: SELECT ONE Row with the MAX() value on a column
body: <p>I have a pretty simple dataset of monthly newsletters:</p>
  
  <pre><code>id  | Name          | PublishDate   | IsActive
  1   |  Newsletter 1 | 10/15/2012    |     1
  2   |  Newsletter 2 | 11/06/2012    |     1  
  3   |  Newsletter 3 | 12/15/2012    |     0
  4   |  Newsletter 4 | 1/19/2012     |     0
  </code></pre>
  
  <p>and etc. </p>
  
  <p>The PublishDate is unique. </p>
  
  <p>Result (based on above):</p>
  
  <pre><code>id  | Name          | PublishDate   | IsActive
  2   |  Newsletter 2 | 11/06/2012    |     1  
  </code></pre>
  
  <p>What I want is pretty simple. I just want the 1 newsletter that IsActive and PublishDate = MAX(PublishDate).</p>