Re: SQL Blues......Part 2 HELP!!!

[Quoted] mAd hAcker <madhackerboy_at_hotmail.com> wrote in message news:yWO85.382$87.2461_at_news1.mts.net...
> Okay, I've tried about everything....I've taken everyone's advice (albeit
> conflicting) one at a time, and still to no avail.
> I am trying to retrieve the top values (determined by actual_points)
> from a table (catch_entries) for each individual player.
> ie: bill's top score, mike's top score, jim's top score, etc.
> Here is the most recent form of my select statement, which returns
 only
> one value - the highest actual_point value overall.
>
> What do I need to do to make it return the highest actual_points value
> per user?????

[Quoted] Use the group by clause in combinatuion with maxvalue.. very simple example:

select player_name, MAX(score)
from t_scores
where ....blabla
group by player_name;

greetz

jan Received on Thu Jul 06 2000 - 00:00:00 CEST