There's probably a way to do that using Oracle OLAP queries in 9i. But I'm not familar with the syntax, sorry.
Tim. On Wed, Jun 04, 2003 at 08:00:17AM -0700, Dean Arnold wrote: > A DBIx::Chart user is experiencing problems with the following query: > > > $rsth = $dbh->prepare( > > "SELECT GRAINS,SUM(GRAINS) FROM SOMETABLE > > RETURNING linegraph(*), imagemap where width=500 and > > AND HEIGHT=500"); > > > > and the again the error: > > > > DBD::Oracle::db prepare failed: ORA-00937: not a single-group > > group function (DBD ERROR:OCIStmtExecute/Describe) > > for statement "SELECT GRAINS,SUM(GRAINS) FROM SOMETABLE" > > > > They claim that the error does not occur when the "RETURNING > linegraph(*)..." clause > is removed. Alas, I don't have an Oracle instance handy to test with, but > was > wondering if "SELECT X, SUM(X) FROM MYTABLE" was valid > Oracle syntax without a GROUP BY clause ? Does that compute a cumulative > sum in Oracle ? > > Any insights much appreciated, > Dean Arnold > Presicient Corp. >
