Group by month and then average

[dhborchardt]

I would like to build a query that would group all records by year/month and then average each month.
For example the output of each row might look like this: "Jan 02, 55" then each row would show subsequent months.

 

[r937]

select format(somedate, "mmm&quot
, format(somedate, "yy&quot
, avg(somevalue)
from yourtable
group
by format(somedate, "mmm&quot
, format(somedate, "yy&quot
order
by 2,1

note that splitting the format into month name and year pieces is necessary to provide a meaningful sort (otherwise, you'd get Apr, Aug, Dec, etc.)

rudy

 

[dhborchardt]

Thank you