three highest and lowest column values

2003-12-30 Thread Roland Niederbrucker
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

Re: three highest and lowest column values

2003-12-30 Thread Roger Baklund
* 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

RE: three highest and lowest column values

2003-12-30 Thread emierzwa
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

three highest and lowest column values

2003-12-29 Thread Roland Niederbrucker
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