Re: SQL Problem. HELP!

Jerry Glass wrote:
>
> I am lookin for a way to solve a problem. I need to find the highest
> values in a list and only return those values (i.e., find the three
> highest values and only return those three rows)
>
> Jerry Glass

I think your problem could be solved with the following query:

[Quoted] SELECT S0.territory, S0.name, S0.amount
FROM SalesReport S0
WHERE 3 > (SELECT COUNT(*) FROM SalesReport S1

            WHERE S1.territory > S0.territory);

Hope it helps,
Claudia Received on Wed Jun 18 1997 - 00:00:00 CEST