471,108 Members | 1,254 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

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
look at analytics. also asktom.oracle.com
Jim
"Prabu Krishna" <pr**********@hotmail.com> wrote in message
news:4d**************************@posting.google.c om...
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.

Similar topics

11 posts views Thread by James | last post: by
9 posts views Thread by netpurpose | last post: by
9 posts views Thread by Dom Boyce | last post: by
5 posts views Thread by Steve Patrick | last post: by
6 posts views Thread by Takeadoe | last post: by
47 posts views Thread by Jo | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.