Get highest 3rd value

Question

How to get 3rd highest value using sql query. table name= tbl_students field name= arrear i need 3rd highest arrear student

Gokul T · Answer

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

Mitesh Gadhiya · Answer

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

Puneet Kankar · Answer

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

Kesavan Krishnan · Answer

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;

Rajkiran Swain · Answer

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

Kesavan Krishnan · Answer

select *, count (arrear) as total_arrear FROM tbl_students where arrear = 1 group by id_student order by total_arrear DESC limit 2, 1

Pramod Thakur · Answer

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

Tapan Patel · Answer

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 Patel · Answer

Select Min(Salary) from( Select Top 3 Salary_Amt as Salary From Salary_Master )t

Gokhul Varman · Answer

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

Get highest 3rd value

Answers (10)