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 2nf in normalization?
how to delete duplicate rows from table
What is deadlock and how to avoid the deadlocks.
How to provide column names in insert statements in ms sql server?
How many types of triggers are there?
How to connect ms access to sql servers through odbc?
How do you create a clustered index?
How use inner join in sql server?
What is difference between delete & truncate commands?
Explain what is the use of custom fields in report?
Do you know what is difference between index seek vs. Index scan?
How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes