CTED]>; "MYSQL" <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 9:30 PM
Subject: Re: select by total goals
> Try:
>
> SELECT SUM(goals) AS leaders
> FROM stats
> GROUP BY [player_field]
> ORDER BY leaders DESC
>
> --jeff
>
> - Original Message
Try:
SELECT SUM(goals) AS leaders
FROM stats
GROUP BY [player_field]
ORDER BY leaders DESC
--jeff
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 6:55 PM
Subject: select by t
hey guys,
I'm working on a script to display the season leading scorers for my
lacrosse site and I don't know how to do the query.
I am trying to display the leaders scorers by total goals throughout the
season, however I don't know how to select the sum of goals by each
individual player then s
hey guys,
I'm working on a script to display the season leading scorers for my
lacrosse site and I don't know how to do the query.
I am trying to display the leaders scorers by total goals throughout the
season, however I don't know how to select the sum of goals by each
individual player then s
