SQL Programming
June 7, 2025 at 03:44 AM
✅ *Answer: C — RANK() OVER(PARTITION BY…)*
To find the top N items per group, we use window functions like RANK() or ROW_NUMBER() along with PARTITION BY to reset ranking within each category. Then, we filter the results using a WHERE clause on the rank.
*React ❤️ if you got it right*
❤️
❤
👍
😂
😢
🙏
😮
108