forum

home / developersection / forums / why does max function in sql return multiple values

Ask Question

Why does max function in sql return multiple values

Jayden Bell 2674 08-May-2013
Hi Everyone!

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).

Thanks in advance!
mssql server mssql server 
Updated on 08-May-2013
Jayden Bell

Other

Message
Can you answer this question?
Answer

1 Answers

AVADHESH PATEL

AVADHESH PATEL

08-May-2013
Hi Jayden!

You did't need MAX nor GROUP BY, just use TOP 1 with ORDER BY Salary DESC. Something like this:

select TOP (1) Salary as highest_salary, p.[Last name]
from tbl_PlayersTable as p, tbl_team as t
where p.Team = t.TeamID
 and TeamID = 1000
ORDER BY Salary  DESC
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy