Write a query to get 2nd maximum salary in an employee table ?
Answers were Sorted based on User's Feedback
Answer / nagarjuna.reddy
select max(sal) from emp where sal <> (select max(Sal) from
emp)
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
Answer / pramod majhi
select max(salary) from employees where salary<(select
max(salary) from employees);
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
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 |
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 |
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 |
Why is there a need for sqlcode and sqlerrm variables?
What are the two types of exceptions in pl/sql?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
what are the types of join and explain each? : Sql dba
what is unique key constraint? : Sql dba
What is procedure and function in sql?
What are string functions in sql?
How do I install sql?
How does rowid help in running a query faster?
What is tuple in sql?
What is pragma in sql?
How does pl sql work?