Re: Help query
From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sat, 06 Sep 2003 16:24:30 GMT
Message-ID: <2Tn6b.374150$Ho3.55916_at_sccrnsc03>
Date: Sat, 06 Sep 2003 16:24:30 GMT
Message-ID: <2Tn6b.374150$Ho3.55916_at_sccrnsc03>
look at analytics. also asktom.oracle.com
Jim
"Prabu Krishna" <prabukrishna_at_hotmail.com> wrote in message
news:4de9020f.0309060813.17f95df3_at_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?
Received on Sat Sep 06 2003 - 18:24:30 CEST