I would like to display the player with the highest salary.

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]

The output is:

highest_salary  Last Name

   8000          Bosh

   7000          Wade

   6000          James

I just want to display (8000 Bosh since he is the player with highest salary).