try using the RANK function... something like select * from table order by RANK desc limit 11.....this will get u the top 11 rows.
regards anandkl On Thu, Sep 9, 2010 at 1:55 PM, Tompkins Neil <neil.tompk...@googlemail.com>wrote: > Yes, but it doesn't work. Basically I want the SUM(players_master.rating) > only to SUM the top 11 players from each team. Any suggestions ? > > Cheers > Neil > > > On Thu, Sep 9, 2010 at 9:17 AM, Ananda Kumar <anan...@gmail.com> wrote: > >> did u try to use LIMIT after ORDER BY >> >> >> On Thu, Sep 9, 2010 at 1:27 PM, Tompkins Neil < >> neil.tompk...@googlemail.com> wrote: >> >>> Any help would be really appreciated ? >>> >>> >>> >>> ---------- Forwarded message ---------- >>> From: Tompkins Neil <neil.tompk...@googlemail.com> >>> Date: Wed, Sep 8, 2010 at 5:30 PM >>> Subject: Query SUM help >>> To: "[MySQL]" <mysql@lists.mysql.com> >>> >>> >>> Hi >>> >>> I've the following query : >>> >>> SELECT total_team_rating, my_teams_id >>> FROM >>> (SELECT players.teams_id AS my_teams_id, SUM(players_master.rating) AS >>> total_team_rating >>> FROM players >>> INNER JOIN players_master ON players.players_id = >>> players_master.players_id >>> WHERE players.worlds_id = 1 AND players.red_cards = 0 AND >>> players.injury_duration_remaining = 0 >>> GROUP BY players.teams_id) s1 >>> ORDER BY s1.total_team_rating DESC >>> >>> This gives me the total of players_master.rating for each >>> players.teams_id. >>> However, I'm wanting to only base the players_master.rating on the top >>> 11 >>> records in the players table for each team. How can I modify my query to >>> achieve this ? >>> >>> Thanks >>> Neil >>> >> >> >