SQL Max Value of Column to choose which row is selected
<p>I'm having a problem with selecting a single row when there are multiple entries for one "callid"</p>

<p>In this case there are two rows being selected:</p>

<pre><code>Assignee           maxTime
Jim Smith         11:31:05
James Smith       17:50:16
</code></pre>

<p>I want to only select a single row that has the greatest time.</p>

<p>Output I want:</p>

<pre><code> Assignee          maxTime
 James Smith      17:50:16
</code></pre>

<p>This is my code: </p>

<pre><code>select Assignee, MAX(TimeResolv) as maxTime 
from heat8..asgnmnt 
where callid ='00539265' 
    and GroupName like '%cs%' 
Group by Assignee
</code></pre>

<p>Help would be appreciated.</p>