I want to know which employee has sold the most goods from a certain category. I can display only employee’s name and sold goods

USE Northwind
SELECT TotalOrder
       ,FullName
       ,CategoryName
FROM vwEmployesAndMostSoldCategories


USE Northwind
SELECT
       FullName
       , MAX(TotalOrder) AS TheMaxSoldUnits
FROM vwEmployesAndMostSoldCategories
GROUP BY FullName[enter image description here][1]


Read more here: https://stackoverflow.com/questions/64944118/i-want-to-know-which-employee-has-sold-the-most-goods-from-a-certain-category-i

Content Attribution

This content was originally published by AlexeyOrel at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: