Re: Help query
From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Sat, 06 Sep 2003 10:03:56 -0700
Message-ID: <0so6b.113856$kP.32138_at_fed1read03>
Date: Sat, 06 Sep 2003 10:03:56 -0700
Message-ID: <0so6b.113856$kP.32138_at_fed1read03>
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? Received on Sat Sep 06 2003 - 19:03:56 CEST