Sample Header Ad - 728x90

DISTINCT on one column and return TOP rows

9 votes
3 answers
30580 views
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 enter image description here
Asked by Neal (93 rep)
May 5, 2017, 03:43 PM
Last activity: Jun 29, 2017, 12:27 PM