title: Sql Server query is not giving proper result
body: <p>I have table <code>SentNewsletters</code>. This table has following columns.</p>
  
  <pre><code>1. ID
  2. Surah_no
  3. Aayt
  4. Sent_date,
  5. Sent_By
  </code></pre>
  
  <p>I want to </p>
  
  <pre><code>select id
       ,surah_no
       ,aayt
       ,sent_date (MAx)
  </code></pre>
  
  <p><code>Sent_by</code>, <code>Surah_no</code> and <code>Aayt</code> have multiple records like Id</p>
  
  <pre><code>ID  Surah_no  aayt  sent_date                 Sent_By
  
  1   1         1     2013-04-08 19:39:26.127   Test
  2   1         1     2013-04-08 20:03:24.920   Test
  3   1         1     2013-04-08 19:39:26.127   Test
  4   1         1     2013-04-08 20:03:24.920   Test
  5   1         1     2013-04-08 20:19:26.033   User3
  6   1         1     2013-04-08 20:24:47.890   User3
  
  select Count(*)
       ,surano
       ,Aaytno
       ,MAx(SENT_DATE) 
  from sentnewsletters 
  group by SuraNo
       ,Aaytno
  </code></pre>
  
  <hr>
  
  <p>I need Id and Sent_By also</p>
  
  <pre><code>select Count(*)
       ID
       ,surano
       ,Aaytno
       ,MAx(SENT_DATE) ,
        Sent_by
  from sentnewsletters 
  group by SuraNo
       ,Aaytno
  </code></pre>