How to Select second Maximum salary in a Table ?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / subbareddy

13 Answers
15812 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to Select second Maximum salary in a Table ?..

Answer / guest

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

Is This Answer Correct ?

20 Yes

3 No

How to Select second Maximum salary in a Table ?..

Answer / tanuj tewari

select max(sal) from table_name where sal<(select max(sal)
from table_name);

Is This Answer Correct ?

15 Yes

3 No

How to Select second Maximum salary in a Table ?..

Answer / sunil

select max(sal) from table_name where
sal<(select max(sal) from table_name);

or

select sal from(select sal,dense_rank() over(order by sal)
as rnk from table_name) where rnk=2;

Is This Answer Correct ?

7 Yes

4 No

How to Select second Maximum salary in a Table ?..

Answer / abhijit

select max(sal) from table_name where
sal<(select max(sal) from table_name);

or

select sal from(select sal,dense_rank() over(order by sal
desc)
as rnk from table_name) where rnk=2;

Is This Answer Correct ?

3 Yes

1 No

How to Select second Maximum salary in a Table ?..

Answer / ranjini

select max(salary) from employee not exists (select
max(salary)from employee)

Is This Answer Correct ?

0 Yes

1 No

How to Select second Maximum salary in a Table ?..

Answer / arpit sachan

select min(Emp_Sal)from Employee_Test where Emp_sal in(select distinct top(2) Emp_Sal from Employee_Test order by Emp_Sal desc)

Is This Answer Correct ?

0 Yes

1 No

How to Select second Maximum salary in a Table ?..

Answer / ranjith

select salary from table order by salaray desc limit 1,1

Is This Answer Correct ?

0 Yes

1 No

How to Select second Maximum salary in a Table ?..

Answer / kuldeep singh

select max(sal) from emp where sal not in (select top2 sal from emp order by sal desc)

Is This Answer Correct ?

1 Yes

3 No

How to Select second Maximum salary in a Table ?..

Answer / sephali

select sal, rownum
from (select sal from table
order by sal desc)
where rownum=2

Is This Answer Correct ?

0 Yes

2 No

How to Select second Maximum salary in a Table ?..

Answer / 9896012055

what will be the answer for this question

Is This Answer Correct ?

0 Yes

3 No

Post New Answer