Get highest 3rd value

Pramod Thakur9y ago

http://www.itbunch.com/sql/find-nth-highest-salary-using-dense_rank-function-in-sql/334/

Tapan Patel9y ago

or something like below (for example, I am querying salary from temptable)

SELECT TOP 1 CE.Salary
FROM (
SELECT DISTINCT TOP 3 Salary FROM #temptable ORDER BY Salary DESC
) AS CE
ORDER BY CE.Salary

Nilesh Patel9y ago

Select Min(Salary)

from(

Select Top 3 Salary_Amt as Salary From Salary_Master

)t

Gokhul Varman9y ago

Please refer the link for more explnation about the highest value:https://www.codeproject.com/Questions/411083/sql-query-for-getting-the-rd-highest-value

Kesavan Krishnan9y ago

Hi,

if have multiple student record for same student

select *, count(arrear) as arrear from tbl_students group by id_student order by arrear DESC limit 2,1

In generic ,

select * from tbl_students order by arrear desc limit 2,1;

Mitesh Gadhiya9y ago

;WITH CTE as (
SELECT dense_rank() over (order by Arrear desc) as r FROM tbl_students
)
select * FROM CTE WHERE r = 3

Puneet Kankar9y ago

WITH CTE AS ( SELECT EmpID,EmpName,EmpSalar, RN = ROW_NUMBER() OVER (ORDER BY EmpSalary DESC) FROM dbo.Salary ) SELECT EmpID,EmpName,EmpSalar FROM CTE WHERE RN = 3

Rajkiran Swain9y ago

https://stackoverflow.com/questions/16234983/how-to-find-third-or-nth-maximum-salary-from-salary-table

Gokul T9y ago

Got it:

SELECT * FROM `tbl_students` ORDER BY `Arrear` DESC LIMIT 1 OFFSET 2;