Posted by Bob Bedford on 02/26/07 20:19

Hi all,

I've a huge number of records in one table and must retrieve them.

Every record has a datetime field and other values (mainly numerical
fields).

My goal is to retrieve min,max,average for every month. In fact I've to
create charts and I can't do that using every day. I've also to know the %
of the record for every month given the entire number of record.
I can get those values then use them in an other pogram to create charts but
I don't know how to retrieve the datas grouping by month.
In pseudo-code:
select min(x), max(x), average(x), numberofrecorpermonth, totalnumber from
mytable group by everymonth
table mytable:
x: integer;
logtime: DateTime

- numberofrecordpermonth is the count of records for every month
- totalnumber is the total count of records

How to do it ? I have not enough knowledge in sql to do it.

Thanks for helping.

Bob

[Back to original message]