Select nth Maximum value without using RANK / MAX

Posted Date: 27 Oct 2009	Resource Type: Code Snippets	Category: SQL
Author: Ramaraj R	Member Level: Silver
Rating:	Points: 4

Query:


Select Salary from Employee a where N = (select count(distinct(salary)) from Employee b where a.salary < b.salary

Note:

Replace the N with the appropriate number. For example if you want to get the second max of salary then replace the N with 2

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Query for Nth Maximum value without using MAX . Nth salary calculate .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to get integer value from float data
	Previous Resource: How to use a Table Variable in T-SQL
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

More Resources

Select nth Maximum value without using RANK / MAX

Responses

Post Feedback

Difference between Rank() and Dense_Rank() in SQL

Using Dense_Rank in SQL server 2005