sql max() function

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

ramses2nd Hall of Fame Points: 3720 More actions · Answer 1

This would work:

SELECT MAX(SALARY)

FROM SALARY

WHERE SALARY < (SELECT MAX(SALARY) FROM SALARY)

Mathew J Kulangara SSCommitted Points: 1610 More actions · Answer 2

I solve this as follows...

This approach would allow you get any rank

Select top 1 Salary

from

(

Select top 2 Salary

from Salary

order by Salary desc

)

order by salary asc

HTH

NNEKA ECHEBE-248394 SSC Journeyman Points: 88 More actions · Answer 3

Thank you so much for your help! it worked like a charm

Wayne Kelley SSC Enthusiast Points: 147 More actions · Answer 4

SSC Enthusiast

Points: 147

February 8, 2006 at 8:23 am

select max(salary)-1 from table_name

Clint SSC Veteran Points: 207 More actions · Answer 5

Wayne, your query would return ((highest salary) - 1), not (second highest salary).

Wayne Kelley SSC Enthusiast Points: 147 More actions · Answer 6

SSC Enthusiast

Points: 147

February 13, 2006 at 12:25 pm

Clint - thanks for clarification.

AMIT GUPTA-263376 SSCarpal Tunnel Points: 4244 More actions · Answer 7

Try this Query :-

select max([2]) from tbl_excel

where [2] not in (select max([2]) from tbl_excel )

----------------------------------------------