Subject | SQL query: how to group by a function |
---|---|
Author | Mirjam Besamusca |
Post date | 2001-07-24T04:22:20Z |
Hi,
I have a SELECT statement in which I want to group the data by the month of
a date field, to calculate monthly averages. GROUP BY does not allow the
month function though - is there any way around this?
Regards,
Mirjam
######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################
I have a SELECT statement in which I want to group the data by the month of
a date field, to calculate monthly averages. GROUP BY does not allow the
month function though - is there any way around this?
Regards,
Mirjam
######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################