471,108 Members | 1,254 Online

# Help query

I having employees records which contanis 100 records,contains
emplyeeid,name,salary as fields
Question 1.
I need to find the 10th maximum salary of the employees

question 2.

I need to find the 60th maximum salary of the employees
Question 3.
I need to find the 10th minimum salary of the employees

question 2.

I need to find the 60th minimum salary of the employees
All this should be done by a query.How is it is possible?
Jul 19 '05 #1
3 1875
Jim
"Prabu Krishna" <pr**********@hotmail.com> wrote in message
I having employees records which contanis 100 records,contains
emplyeeid,name,salary as fields
Question 1.
I need to find the 10th maximum salary of the employees

question 2.

I need to find the 60th maximum salary of the employees
Question 3.
I need to find the 10th minimum salary of the employees

question 2.

I need to find the 60th minimum salary of the employees
All this should be done by a query.How is it is possible?

Jul 19 '05 #2
Prabu Krishna wrote:
I having employees records which contanis 100 records,contains
emplyeeid,name,salary as fields
Question 1.
I need to find the 10th maximum salary of the employees

question 2.

I need to find the 60th maximum salary of the employees
Question 3.
I need to find the 10th minimum salary of the employees

question 2.

I need to find the 60th minimum salary of the employees
All this should be done by a query.How is it is possible?

For which school, class & instructor gave you this assignment?

Jul 19 '05 #3
use rownum = 10 before group by

pr**********@hotmail.com (Prabu Krishna) wrote in message news:<4d**************************@posting.google. com>...
I having employees records which contanis 100 records,contains
emplyeeid,name,salary as fields
Question 1.
I need to find the 10th maximum salary of the employees

question 2.

I need to find the 60th maximum salary of the employees
Question 3.
I need to find the 10th minimum salary of the employees

question 2.

I need to find the 60th minimum salary of the employees
All this should be done by a query.How is it is possible?

Jul 19 '05 #4

### This discussion thread is closed

Replies have been disabled for this discussion.