three highest and lowest column values

[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