how to select second mauximum value in a given table under salary column

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

Question Posted / vemulajk4u

6 Answers
7780 Views
Sapient, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to select second mauximum value in a given table under salary column..

Answer / jai

SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?

27 Yes

2 No

how to select second mauximum value in a given table under salary column..

Answer / sonthosh

SELECT * FROM
(
SELECT
NAME
,SALARY
,RANK() OVER (order by salary desc) RANK
FROM EMPLOYEE)
WHERE RANK = 2

Is This Answer Correct ?

7 Yes

4 No

how to select second mauximum value in a given table under salary column..

Answer / utkal

Select distinct(E1.Salary) from EMPLOYEE E1 where 2 =
(Select Count(distinct(E2.Salary)) from Employe E2 where
E1.Salary <= E2.Salary).

Here n=2,

Similarily we can find the 5th highest salary etc...

Is This Answer Correct ?

2 Yes

0 No

how to select second mauximum value in a given table under salary column..

Answer / u.radha

SELECT * FROM (SELECT ENAME,SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RN FROM EMP) WHERE RN = 2;

Is This Answer Correct ?

2 Yes

0 No

how to select second mauximum value in a given table under salary column..

Answer / shri

select min(sal) from (select * from emp order by sal desc) where rownum<3

IN Informatica also use the query in source qualifier's
"sql override". which will reduce d no. of t/r in d mapping

Is This Answer Correct ?

3 Yes

3 No

how to select second mauximum value in a given table under salary column..

Answer / ramesh

create table emp(sal number(5,2);

Is This Answer Correct ?

1 Yes

19 No

Post New Answer