File: SAMPLES\DATA\TOPTEN.QPR
This query displays the top ten selling products based on sales recorded in the Order Items table. The query uses the TOP n feature of the SELECT statement. Because the order is set to DESCENDING, ordering by the sum of price and quantity returns the 10 highest values.
SELECT TOP 10 Products.prod_name,; SUM( Orditems.unit_price* Orditems.quantity); FROM testdata!products INNER JOIN testdata!orditems ; ON Products.product_id = Orditems.product_id; GROUP BY Products.prod_name; ORDER BY 2 DESC