SELECT B.Team,B.Score ; FROM mytable A INNER JOIN mytable B ; ON A.Team = B.Team ; AND A.Score => B.Score; GROUP BY B.Team,B.Score ; HAVING COUNT(*) <= 3 ; ORDER BY B.Team,B.Score Desc