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 <anandkl@stripped> wrote:
> did u try to use LIMIT after ORDER BY
>
>
> On Thu, Sep 9, 2010 at 1:27 PM, Tompkins Neil <
> neil.tompkins@stripped> wrote:
>
>> Any help would be really appreciated ?
>>
>>
>>
>> ---------- Forwarded message ----------
>> From: Tompkins Neil <neil.tompkins@stripped>
>> Date: Wed, Sep 8, 2010 at 5:30 PM
>> Subject: Query SUM help
>> To: "[MySQL]" <mysql@stripped>
>>
>>
>> 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
>>
>
>
