find out the third highest salary?
Answers were Sorted based on User's Feedback
Answer / mihir nasikkar
Here n is 3
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / karunakar varma
select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / abbas
SELECT * FROM
(
SELECT EMPLOYEECODE, SAL, Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMPLOYEE)
WHERE RANKNEW = 3
Is This Answer Correct ? | 9 Yes | 8 No |
Answer / mahesh
select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))
Is This Answer Correct ? | 11 Yes | 10 No |
Answer / nirad
select Top 1 *
from ( select top 3 * from Customer order by salary desc )
tempt
order by salary asc
if you want third lowest just desc with asc and asc with
desc and even if you want 2 or other hight value just
change inner query value of 3
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / chinmaya
Select Top 1 Sal from (Select Top 3 Sal from emporder by
Sal desc) x order by Sal
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vanaja
select * from emp5 where salary in(select min(salary) from
emp5 where salary in(select top 3 salary from emp5 order by
salary desc))
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ajit
SQL QUERIES FOR FINDING Nth HIGHEST SALARY
SELECT DISTINCT (a.salary) FROM EMPLOYEES A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM EMPLOYEES B WHERE a.salary<=b.salary);
Is This Answer Correct ? | 1 Yes | 0 No |
How to define an anonymous block?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
What do you mean by a deadlock?
What is user managed backup in Oracle?
Differnce between view and index
How to change user password in oracle?
What is index-organized table in Oracle?
how can we store any pdf file in oracle
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to use windows user to connect to the server?
What are a cluster and non-cluster index?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?