From: Ananda Kumar
Date: September 9 2010 8:17am
Subject: Re: Query SUM help
List-Archive: http://lists.mysql.com/mysql/222895
Message-Id: <AANLkTinsrk0uuO0SGWMj72WsE+_rBxC4df4FU_oTgT0O@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e659f62c148dc3048fcf42d1

--0016e659f62c148dc3048fcf42d1
Content-Type: text/plain; charset=ISO-8859-1

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
>

--0016e659f62c148dc3048fcf42d1--