Re: 'GROUP BY' behavior

Bill Adams wrote: Shawn, That's a very reasonable answer. Thanks for pointing me to the examples. This one addresses the second question: http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row. html . There is no example answering both questions in one query. Regards, Bill

RE: 'GROUP BY' behavior

Shawn, That's a very reasonable answer. Thanks for pointing me to the examples. This one addresses the second question: http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row. html . There is no example answering both questions in one query. Regards, Bill __

Re: 'GROUP BY' behavior

"Bill Adams" <[EMAIL PROTECTED]> wrote on 10/28/2005 01:49:28 PM: > All, > > In the following query, some of the values are averaged over several > rows, but some are not: > > SELECT hostname, volname, qtreename, round(avg(used/allocated*100),0), >round(avg(used)), allocated, available >

'GROUP BY' behavior

All, In the following query, some of the values are averaged over several rows, but some are not: SELECT hostname, volname, qtreename, round(avg(used/allocated*100),0), round(avg(used)), allocated, available FROM quota_entries WHERE date_sub(now(), interval 1 day) < time