AND b.MarketId=a.MarketId
AND b.Type=a.Type
AND b.Price<=a.Price)
ORDER BY ProductId, MarketId, Type, Price
Thanks,
Ed
>Subject: Re: three highest and lowest column values
>* Roland Niederbrucker
> from the following Product-table
>
> ProductId
* Roland Niederbrucker
> from the following Product-table
>
> ProductId
>
> MarketId
>
> CustomerId
>
> Type
>
> Price
>
> ...
>
> i would like to get the three highest and lowest prices
>
> for each group of ProductId,MarketId & Type.
>
> How could i do that ???
Do you use a programming language,
Hello,
from the following Product-table
ProductId
MarketId
CustomerId
Type
Price
...
i would like to get the three highest and lowest prices
for each group of ProductId,MarketId & Type.
How could i do that ???
Many thanks in advance
roland
Hello,
from the following Product-table
ProductId
MarketId
CustomerId
Type
Price
...
i would like to get the three highest and lowest prices
for each group of ProductId,MarketId & Type.
How could i do that ???
Many thanks in advance
roland
