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
* 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, or are you looking
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
MarketId
CustomerId
Type
Price
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