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

It works fine when I only include the fields "pin" and max(actual_points) but whenever I add another field, it gives me a group by error.

ie: "select pin, max(actual_points) from catch_entries groupy by pin order by max(actual_points) desc" works fine... BUT
"select pin, max(actual_points), date_caught from catch_entries groupy by pin order by max(actual_points) desc"
produces an error saying not a group by expression.....

Any clues?

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


>

> mAd hAcker <madhackerboy_at_hotmail.com> wrote in message

> news:4s095.1881$87.4703_at_news1.mts.net...

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

>

> I'm not sure but i think it has something to do with te fact that you're

> also selecting columns  that have specific data thats different for

 multiple


> rows.

> Maybe you should trie to select at first only player_name and max_point

> make that one work and gradualy make your query larger..

>

> greetz

>

> Jan

> (taking OCP exam 1 next week..)

>

>

>

>

>

>