Skip to main content
nikos101
nikos101
Inspiring
December 18, 2008
Question

I have a challanging query problem

  • December 18, 2008
  • 2 replies
  • 594 views
I have a challanging problem. I have a datetime column and a numerical column. I need a query that returns a set of the average of the numerical column per month.

Note my data is spread over years so I need to group by mm yy
This topic has been closed for replies.

2 replies

nikos101
nikos101Author
Inspiring
December 18, 2008
Wait a minute I think this is it:

SELECT SUBSTRING(CONVERT(VARCHAR(8), valueDate, 3), 4, 5) AS mmyy
,avg(rate)
FROM [commercial].[dbo].[OTT_DEALS]
group by SUBSTRING(CONVERT(VARCHAR(8), valueDate, 3), 4, 5)
nikos101
nikos101Author
Inspiring
December 18, 2008
The best I can come up with so far is:

SELECT SUBSTRING(CONVERT(VARCHAR(8), valueDate, 3), 4, 5) AS mmyy
,avg(rate)
FROM [commercial].[dbo].[OTT_DEALS]
group by valueDate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices