Re: Help query
From: lokys <i4paga_at_yahoo.com>
Date: 7 Sep 2003 13:16:09 -0700
Message-ID: <3d5fe109.0309071216.4852d2a2_at_posting.google.com>
Date: 7 Sep 2003 13:16:09 -0700
Message-ID: <3d5fe109.0309071216.4852d2a2_at_posting.google.com>
use rownum = 10 before group by
prabukrishna_at_hotmail.com (Prabu Krishna) 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 Sun Sep 07 2003 - 22:16:09 CEST