Write a query to get 2nd maximum salary in an employee table ?

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

Question Posted / wgk

69 Answers
102650 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Write a query to get 2nd maximum salary in an employee table ?..

Answer / nagarjuna.reddy

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

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / sandip

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

I don't think this will work correct me if i am
wrong.Correct one is-------

SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / sandip

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

The correct one is.......

SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / pramod majhi

select max(salary) from employees where salary<(select
max(salary) from employees);

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / srinivas

select max(salary) from Emp where salary<(select max(salary) from Emp)

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / sushma

SELECT * from
(SELECT * FROM emp ORDER BY sal DESC)
WHERE rownum <= 2
MINUS
SELECT * from
(SELECT * FROM emp ORDER BY sal DESC)
WHERE rownum < 2

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / debasish sinha

select ename,sal,deptno
from emp
where sal =
(
select max(sal)
from emp
where level=2
connect by prior sal>sal
group by level
)

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / veera

SELECT * FROM EMP A WHERE &N-1=(SELECT COUNT(DISTINCT SAL) FROM EMP B WHERE A.SAL<B.SAL) ORDER BY SAL

Pass Paramenter :2..it will give the 2nd maximum salary

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / lalit raghuvanshi

I got the solution:
Multiple Sql server queries to get second,third,fourth or nth highest/maximum salary from employee table
http://www.webcodeexpert.com/2014/08/sql-server-query-to-get.html

Is This Answer Correct ?

0 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / ashish jain

select Salary from
(
select salary,ROW_NUMBER() over (order by salary desc) as rownum from Emp group by salary) temp
where rownum=2

Note :It can be used to get any highest salary, just use where rownum=nth salary

Is This Answer Correct ?

0 Yes

0 No

Post New Answer