title: Max sql server without group by
body: <pre><code>    CallID  StartTime           EndTime                 Querytime
      1692    2012-11-20 11:52:00.000 2012-11-20 11:52:00.300 0.300
      1693    2012-11-20 11:52:00.000 2012-11-20 11:52:00.100 0.100
      1694    2012-11-20 11:52:00.000 2012-11-20 11:52:00.400 1.5
      1695    2012-11-20 11:52:01.000 2012-11-20 11:52:01.400 3
      1696    2012-11-20 11:52:01.000 2012-11-20 11:52:01.300 5
  </code></pre>
  
  <p>I would like to get the maximum querytime grouped by the StartTime like below but i still want CallID to be shown.</p>
  
  <pre><code>     StartTime                  MaxQueryTime
       2012-11-11 19:04:07.000    0.300
       2012-11-11 19:04:10.000    0.200
       2012-11-11 19:08:48.000    0.300
       2012-11-11 19:08:51.000    0.300
       2012-11-11 19:09:27.000    0.100
  
       SELECT     StartTime, MAX(Querytime) AS QueryTime
       FROM         dbo.Calls
       GROUP BY StartTime
  </code></pre>