how to find nth highest salary
Answers were Sorted based on User's Feedback
Answer / sameera chiluka
select secondMAXsal from emp
WHERE seconMAXsal = ((MAXsal)-1);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / amarjit singh
--display 3rd higest salary in MSSQLSERVER
select max(sal) from emp
where sal <(select max(sal) from emp
where sal <(select max(sal) from emp
))
--By , STUDENT OF IET BHADDAL ENG COLLEGE
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / balindra sahani
select max(salary) from table_name where max(salary)not
in(select top(n) from table_name order by salary asc)
where n=nth number salary
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mangalesh porwal
HERE N IS THE NO WHICH HIGHEST NO U WANT..........
IT SURELY WORKS.....
SELECT TOP 1 * FROM (SELECT TOP N * FROM (SELECT ROLLNO FROM TABLE_NM ) AS D ORDER BY ROLLNO DESC) AS P ORDER BY ROLLNO
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / p rem satyam
This is perfect
...............................
select * from emp e1 where (N-1)=( select
count(distinct(e2.sal) from emp e2 where e2.sal > e1.sal)
where N is level of sal. suppose you want 3rd higest sal then
in place u write 3 i.e write (3-1).
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venuprasadh
SELECT MIN(SALARY) AS Salary FROM user WHERE SALARY IN
(SELECT DISTINCT TOP 3 SALARY FROM user ORDER BY SALARY DESC);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ravikiran
select * from employee.e1 where (n-1) =
( select (distinct b.salary ) from employee.e2 where e1.salary > e2.salary
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / amit kumar
--- Getting 4th highest salary
--- 4 can be replaced with any number
with EmpSal as
(Select *, row_number() over (order by EmpSal Desc)
as 'rownumber' from employee)
Select * from EmpSal where rownumber =4
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / neeraj kumar
select top(1) salary from(
select distinct nth salary
from emp
order by salary desc)a
order by salary
In this answer you can put any position in place of nth then you find the salary.
If you are satisfied this answer then reply me please.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jeevan
CREATE TABLE
[dbo].[Table_1]([ID] [int] NOT NULL,[SAL] [int] NULL)
//N=9
SELECT TOP 1 * FROM dbo.Table_1
WHERE ID NOT IN (SELECT TOP 8/*N-1*/ ID FROM dbo.Table_1
ORDER BY SAL DESC)
ORDER BY SAL DESC
Is This Answer Correct ? | 0 Yes | 0 No |
What are 3 ways to get a count of the number of records in a table?
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
Can you please explain the difference between function and stored procedure?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Why and when do stored procedure recompile?
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
event classes in sql server
What is data modeling and Reterminal integrity?
SQL Server Architecture ?
How to insert data with null values?
What is your recommendation for a query running very slow? : sql server database administration
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security