easy5 pts · first answer countswindow-functionssqlranking

Top 3 products in each category

You need the three best-selling products in each category, exactly three rows per category even if sales tie. Which approach fits?

A.ROW_NUMBER() per category by sales DESC, keep rn <= 3B.ORDER BY sales DESC LIMIT 3 on the whole tableC.GROUP BY category, keeping the three largest MAX(sales)D.DENSE_RANK() per category by sales DESC, keep rank <= 3

Discussion 0

Join free to post in the discussion.

Top 3 products in each category

Discussion 0

Related questions