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? > >I am only trying to group on Time_stamp. > >Thank you in advance > >SELECT > ROUND(AVG(COUNT(Time_stamp))), > MIN(COUNT(time_stamp)), > MAX(COUNT(time_stamp)), > Time_stamp > FROM > cp_license_use > Where time_stamp = parmTime > and time_stamp >= SYSDATE-7 > group by Time_Stamp)
This SQL statement does not make any sense to me. What are you trying to do, exactly? --------------------------------------------------------------------- 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
