Skip to content
Advertisement

How to check in which category each employee has sold the most goods? I can display only employee’s name and sold goods

The whole table

What I am only able to output

enter image description here

Advertisement

Answer

You could use a TOP query here:

If a given employee might be tied for having two or more categories with the same order total, and you want to show all ties, then replace ROW_NUMBER, with RANK.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement