SQL Query

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

rohitdeepu17
Profile Answers by rohitdeepu17 Questions by rohitdeepu17
Mar 8th, 2013
1
6488

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

Showing Answers 1 - 1 of 1 Answers

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
 