title: How get rows with max date from group?
body: <pre><code>Table1    
  Id, CatygoryId, Name, DataCreate
  </code></pre>
  
  <p>I want group this data by and get from group rows with max DataCreate</p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>Id   CatygoryId   Name   DataCreate
  
  1       1         Name1  10/08/2016
  2       1         Name2  11/08/2016
  3       1         Name3  12/08/2016
  4       1         Name4  13/08/2016
  5       2         Name5  18/08/2016
  6       2         Name6  19/08/2016
  </code></pre>
  
  <p>In result of query I want get</p>
  
  <pre><code>4       1         Name4  13/08/2016
  6       2         Name6  19/08/2016
  </code></pre>