how to calculate the 2nd max salary in a emp table.

iknow

Hi All

I have a employee table with a salary field. How to calculate the second maximum salary in the employee table. Please provide the query.

sridevi2005 · New User Joined: 15 Sep 2005 Posts: 45

Hi,

Try the following query.

Select min(salary) from employee
where salary > select salary from employee
where salary > avg(sal).

Please let me know if u have any query.

Thanks,
Sridevi

mathiprakash · Posted: Thu Oct 13, 2005 12:26 pm Post subject:

Hi,

This topic has already been disscussed so many times.

Not only the second maximum, you can find for any Nth max of a column.

For more information,
http://www.ibmmainframes.com/viewtopic.php?t=1472&highlight=maximum

Regards,
Matty.

radhakrishnan82 · Posted: Thu Oct 13, 2005 12:30 pm Post subject:

try this code:

Kotes · New User Joined: 03 May 2005 Posts: 12

Hi Iknow,
What radhakrishnan wrote is sucessfully works.

jeyakanthan · New User Joined: 18 May 2005 Posts: 13 Location: chennai

this is simple query
select max(salary) from emp-table where salary NOT IN
(select max(salary) from emp-table)

nijugopalan · New User Joined: 15 Oct 2005 Posts: 15 Location: pune

select max sal from emp where sal<(select max sal from emp)

is this correct