Re: SQL Problem. HELP!

[Quoted] Don't think that the answer that Claudia gave u is the corrent one.

[Quoted] Tell me if she is right.

                                        Yariv

Claudia Bock <suwelack_at_self.de> wrote in article <33A83D7B.4504_at_self.de>...
> 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:
>
> 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 Thu Jun 19 1997 - 00:00:00 CEST