Top n in group by
From: C. Lo <starshipdb_at_hotmail.com>
Date: 26 Mar 2004 10:07:11 -0800
Message-ID: <713a6263.0403261007.39aa08e6_at_posting.google.com>
Date: 26 Mar 2004 10:07:11 -0800
Message-ID: <713a6263.0403261007.39aa08e6_at_posting.google.com>
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 - 19:07:11 CET