title: Retrieve records who one field is max
body: <p>I have some records </p>
  
  <pre><code>id     title     date
  1      aaa       2005
  2      bbb       2003
  3      aaa       2007
  4      ccc       2005
  5      ccc       2009
  </code></pre>
  
  <p>I need to query to retrieve records by Date is max</p>
  
  <pre><code>id     title     date
  2      bbb       2003
  3      aaa       2007
  5      ccc       2009 
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>select * 
  from Table 
  where Table.date = (SELECT Max(date) 
                      FROM Table temp 
                      WHERE temp.title = Document.title)
  </code></pre>
  
  <p>I have sql query but need Linq query for this action</p>