Thanks Sergey. I will give it a try. I appreciate your time.


>Fred,
>Try

>SELECT suppliercode, productcode, dollarsales
>	FROM mytable mt1
>	WHERE dollarsales IN (
>		SELECT TOP 10 dollarsales
>			FROM mytable mt2
>			WHERE mt2.suppliercode = mt1.suppliercode
>				AND mt2.productcode = mt1.productcode
>			ORDER BY dollarsales DESCENDING)	
>

>
>>I have a table with suppliercode,productcode,dollarsales
>>
>>I want the top 10 product codes for each suppliercode. Is this possible