How to display nth lowest record in a table for example? How to display 4th lowest (salary) record from customer table?

Read Best Answer

Editorial / Best Answer

Answered by: Yadnesh

• Jun 1st, 2013

---

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtain derived column using DENSE_RANK() in a subquery and -- obtain temporary result set and finding nth record in a temporary result set using WHERE clause -- for the given example, following is the solution.

Code
SELECT x.rate
,x.rankedSalary
FROM (SELECT rate
                ,DENSE_RANK() OVER (ORDER BY rate) AS rankedSalary
                FROM HumanResources.EmployeePayHistory
                GROUP BY rate) x
WHERE x.rankedSalary = 4

Yadnesh

• Jun 1st, 2013

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtai...

Improve Answer