how to find nth highest salary
Answers were Sorted based on User's Feedback
Answer / deepak dabi
I Think this is the best solution ever i have seen ,i
appriciate if you prove me wroong on this so,otherwise i got
all other a bit wrong ,in many cases please try this....
"SELECT distinct(sal) from emp order by sal desc limit 2,1"
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / amit
Select salary
from employees
order by salary desc
limit n-1,1;
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / chandra sekhar
select min(salary) from emp where salary in (select top n salary from emp order by salary desc)
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / anuj somvanshi
select salary from emp where rownum=n order by salary desc;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / divya
Select Salary
From Employee
Where rowid = n
Order By Salary Desc;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / lakshmi reddy
To get nth highest salary from Employee table:
select * from Employee e where n=(select COUNT(distinct sal)
from Employee e2 where e2.Sal>e.Sal)
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sharmila shree
SELECT TOP 1 salary FROM
( SELECT DISTINCT TOP 1 salary FROM table_name
ORDER BY salary DESC )
a ORDER BY salary
here 'a' is sub query of salary
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sitakanta rath
SELECT sal FROM
(
SELECT DENSE_RANK() OVER (ORDER BY sal DESC) AS rank, sal
FROM Emp
) T2
WHERE rank=@n
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / ajay kumar barik
select a.id from product a where (1= (select count(b.id)
from product b where b.id>=a.id))
It is for all database
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ankur bakliwal
I think this should work -
select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc) order by
salary asc
Is This Answer Correct ? | 0 Yes | 3 No |
What is an expression in ms sql server?
How to define and use table alias names in ms sql server?
How do you create a clustered index?
Does partitioning ssd reduce performance?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What is stored procedures?
Wht is Stuff in sql ser
Tell me when is the update_statistics command used?
What is the significance of null value and why should we avoid permitting null values?
how you can list all the tables in a database?
What is a SQL Server Temporary Table?
How to receive returning result from a query?