title: Sql get latest records of the month for each name
body: <p>This question is probably answered before but i cant find  how to get the latest records of the months.</p>
  <p>The problem is that I have a table with sometimes 2 row for the same month. I cant use the aggregate function(I guess) cause in the 2 rows, i have different data where i need to get the latest.</p>
  <p>Example:<br></p>
  <pre><code>name        Date   nuA  nuB nuC     nuD
  test1   05/06/2013  356 654 3957    7033
  test1   05/26/2013  113 237 399     853
  test3   06/06/2013  145 247 68      218
  test4   06/22/2013  37  37  6       25
  test4   06/27/2013  50  76  20      84
  test4   05/15/2013  34  43  34      54
  </code></pre>
  <p>I need to get a result like:</p>
  <pre><code>test1   05/26/2013    113    237   399   853
  test3   06/06/2013    145    247   68    218
  test4   05/15/2013    34     43    34    54
  test4   06/27/2013    50     76    20    84
  </code></pre>
  <p>** in my example the data is in order but in my real table the data is not in order.</p>
  <p>For now i have something like:</p>
  <pre><code>SELECT     Name, max(DATE) , nuA,nuB,nuC,nuD
  FROM         tableA INNER JOIN
  Group By  Name, nuA,nuB,nuC,nuD
  </code></pre>
  <p>But it didn't work as i want.</p>
  <p>Thanks in advance</p>
  <h1>Edit1:</h1>
  <p>It seems that i wasn't clear with my question...
  So i add some data in my example to show you how i need to do it.
  Thanks guys</p>