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