Chris Comparini wrote:
Try something like this:
select hour(time) as the_hour, avg(temp_f) as average_temp_f
from data
where time > now() - interval 24 hour
group by the_hour;
Thanks Chris. Question though, why is it that when I change that to
48 hours, it only gives me 24 results (starting 48 hours ago to 24 hours
ago) as opposed to 48 results (starting 48 hours ago to now) ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]