title: MAX() Function not working as expected
body: <p>I've created sqlfiddle to try and get my head around this <a href="http://sqlfiddle.com/#!2/21e72/1" rel="nofollow">http://sqlfiddle.com/#!2/21e72/1</a></p>
  
  <p>In the query, I have put a <code>max()</code> on the compiled_date column but the recommendation column is still coming through incorrect - I'm assuming that a select statement will need to be inserted on line 3 somehow?</p>
  
  <p>I've tried the examples provided by the commenters below but I think I just need to understand this from a basic query to begin with.</p>