How do you query for three unique customers with the largest
Purchase_Cost
?
I want to apply the DISTINCT
only on Customer_Name
, but the query below applies the distinct on all three columns. How should I modify the query to obtain the desired output?
SELECT DISTINCT TOP 3 customer_name, order_no, Purchase_Cost
FROM PurchaseTable
ORDER BY Purchase_Cost

Asked by Neal
(93 rep)
May 5, 2017, 03:43 PM
Last activity: Jun 29, 2017, 12:27 PM
Last activity: Jun 29, 2017, 12:27 PM