Top n in group by

Hi,

I'm looking for a way to get the top n results in each group.

ie. in my database of players:
Select TeamName, PlayerName, Goals
From playerList
where age<20
group by teamName, PlayerName, Goals

I'm looking for the top n players in each team with the most goals with age<20.

Thanks for your help. Received on Fri Mar 26 2004 - 12:07:11 CST