can anybody tell us, how to select 2nd max salary from table. my id is ashish

Categories >> Software >> Databases >> SQL Server
Suggest New Category

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / ashish

28 Answers
31755 Views
IBM, Symphony, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / arun ashok

Select max(salary) from employee where salary not in (select
max(salary) from employee)

Is This Answer Correct ?

1 Yes

1 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / sandeep rana

Select top 1 salary from table where salary in(select top 2
salary from table order by salary desc)order by salary

Is This Answer Correct ?

0 Yes

0 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / pravin

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

Is This Answer Correct ?

0 Yes

0 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / prasad237

with x as(select row_number over(order by sal desc) as rid,* from emp)
select * from x where rid=n
we can retrieve nth max sal

Is This Answer Correct ?

0 Yes

0 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / syaam

select a.sal from emp a
where 2=(select count(distinct b.sal) from emp b
where a.sal<= b.sal)

for getting nth max sal ..replace 2 by n

all the best

Is This Answer Correct ?

0 Yes

1 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / swapnl

select max(sal) from emp_det where sal not in (
select max(sal) from emp_det);

Is This Answer Correct ?

0 Yes

1 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / raj

Sabin's answer is perfect and simple

Is This Answer Correct ?

0 Yes

1 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / kumar

1 My Second Answer.

Select Top 1 * From Tablename where salary in
(select top 2 salary from tablename order by salary desc)
order by salary asc.

Is This Answer Correct ?

0 Yes

4 No

Post New Answer