Get the second highest value in a column
Here are step-by-step instructions to get the second highest value in a column.
I recently had the need to retrieve the second highest value in a column. Here are the steps I used:
select max(SALARY) from EMPLOYEE where SALARY < (select max(SALARY) from EMPLOYEE) Note -- If you want the entire record, try this: select * from EMPLOYEE where SALARY = ( select max(SALARY) from EMPLOYEE where SALARY < (select max(SALARY) from EMPLOYEE)
==================================
MORE INFORMATION ON THIS TOPIC
==================================
The Best Web Links: tips, tutorials and more.
Visit the ITKnowledge Exchange and get answers to your developing questions fast.
Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.