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