ORA-00937: not a single-group group function
From: Michael Stowe <Michael.Stowe_at_f573.n115.z1.fidonet.org>
Date: Wed, 27 Apr 94 03:07:00 -0600
Message-ID: <3b828a9e_at_f573.n115.z1.fidonet.org>
Date: Wed, 27 Apr 94 03:07:00 -0600
Message-ID: <3b828a9e_at_f573.n115.z1.fidonet.org>
- Quoting Pgs1002_at_Esc.Cam.Ac.Uk to All dated 04-26-94 ***
> select min(depth), plane.unique_id from
> plane, observation
> where (plane.core = 13 and
> observation.plane = plane.unique_id and
> observation.contents = 56);
If you wish to calculate min(depth) for each set of unique_id's, you must
follow this SQL statement with
GROUP BY plane.unique_id;
Received on Wed Apr 27 1994 - 11:07:00 CEST