title: Why does max function in sql return multiple values
body: <p>I would like to display the player with the highest salary.</p>
  
  <pre><code>select  max(Salary) as highest_salary, p.[Last name]
  from tbl_PlayersTable as p, tbl_team as t
  where p.Team = t.TeamID
  and TeamID = 1000
  Group by p.[Last name]
  </code></pre>
  
  <p>The output is:</p>
  
  <pre><code>highest_salary  Last Name
     8000          Bosh
     7000          Wade
     6000          James
  </code></pre>
  
  <p>I just want to display (8000 Bosh since he is the player with highest salary).</p>