I am looking for a query that will single out a SKU with the maximum number of sales. I have a table that shows a SKU's material code, sales and SKU number. What I need the query to do is find the MAX sales, (1831 in the below instance) and return only the line with 0CXX2005300CP.
Material...