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

From: mAd hAcker <madhackerboy_at_hotmail.com>
Date: 2000/07/06
Message-ID: <4s095.1881$87.4703_at_news1.mts.net>#1/1


[Quoted] Okay, I tried that.....but I keep getting an error - "ORA-00979: not a GROUP BY expression"
Why isn't it a GROUP BY expression?

--
"jAnO!" <j.j.groot_at_kpn.com> wrote in message
news:8k1iql$f7a$1_at_hdxl22.telecom.ptt.nl...

>
> 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?????
>
> 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

Original text of this message