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
I just want to display (8000 Bosh since he is the player with highest salary).
Thanks in advance!