SELECT ROUND(AVG(COUNT(Time_stamp))), MIN(COUNT(time_stamp)), MAX(COUNT(time_stamp)) FROM cp_license_use Where time_stamp = parmTime and time_stamp >= SYSDATE-7 group by Time_Stamp)
On Mon, Jan 28, 2002 at 05:27:15PM -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) > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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