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.


This was first published in July 2005

Dig deeper on Data backup, storage and retrieval on iSeries

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close