Re: HELP! Group By will only allow 2 fields.....Why?

From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 2000/07/06
Message-ID: <8k2m6b$ror$1@crax.cesnet.cz>#1/1

In comp.databases.oracle.misc mAd hAcker <madhackerboy_at_hotmail.com> wrote:
: For Example:
: "SELECT pin, max(actual_points)
: FROM catch_entries
: GROUP BY pin
: ORDER BY max(actual_points) DESC"
: Works just fine......but when I do this:
: "SELECT pin, max(actual_points), adjusted_points
: FROM catch_entries
: GROUP BY pin
: ORDER BY max(actual_points) DESC"
: I get an error message :
: ERROR at line 1:
: ORA-00979: not a GROUP BY expression

All columns listed in GROUP BY clause have to be listed in the same order after SELECT keyword and then is possible to use some agregate functions.

Starous Received on Thu Jul 06 2000 - 00:00:00 CDT