Posted by Jim S. on 07/18/05 19:56

ok, am not sure that that query does what i need, since ranking is a
variable, for example:
category , a, b, c
under category each category, there is a list of products, each having
its own number (ranking) , now that number could be 5, 1000, 1 or any

so what i want is the "TOP 3" numbers (ranking) of each categoy.
thanks.
Note: I never used "between" before, i will check it out, and hopefully it
can be tweaked to fit the purpose. thanks again, and i hope u reply back.


"ZeldorBlat" <zeldorblat@gmail.com> wrote in message
news:1121703556.229410.298030@g43g2000cwa.googlegroups.com...
> select *
> from my_table
> where ranking between 1 and 3
> order by category, ranking
>

[Back to original message]