SELECT *
FROM (
SELECT
team,
player,
score,
ROW_NUMBER() OVER (PARTITION BY team ORDER BY score DESC) AS rank_in_team
FROM scores
)
WHERE rank_in_team <= 3;Backlinks
- Reliability checklist
Pre-deploy checklist for small infra and app changes.
Local Graph
2 nodes · 1 edges
Drag, mouse wheel, `+` / `-`, `0`, arrow keys