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 is the purpose of using COLLATE in a query?
What is a recursive stored procedure in sql server?
What happens when unicode strings concatenate with non-unicode strings?
What is indexing explain it with an example?
Are semicolons required at the end of sql statements in sql server 2005?
What method is used by the Command classes to execute SQL statements that return single values?
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?
Do you know how to implement service broker?
Ms sql server index?
What are the steps to insert a table?
What are the features of Embedded SQL
What are the components of dbms?