Lance,
Lance,
You are asking for help in the wrong place. MySQL doesn't issue Oracle
error messages. Only Oracle issues Oracle error messages. Try www.oracle.com.
When you go there, they will surely ask you what in the world you are
trying to do. They might suggest that you start by defining a view that
includes just
SELECT COUNT(0) as count, time_stamp
FROM cp_license_use
GROUP BY tiime_stamp
and then run your statistics against that view.
They might even make sure you understand that an Oracle DATE column
includes time down to milliseconds, and that therefore there is some danger
that your GROUP BY will have a granularity in milliseconds, where it is
pretty clear that you actually want to group by days.
--Erv
At 05:27 PM 1/28/2002 -0800, Lance Prais wrote:
>Why when I use the following SQL it get a
>ORA-00937: not a single-group group function
>
>What could I be doing wrong?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
