3 month rolling/moving average

Asked Jul 11 '17 at 19:37

Active Jul 11 '17 at 21:07

Viewed 586 times

Somehow this is not the initial request I have put forward. Indeed there are similar requests however as per my previous and initial message I tried the examples already delivered and some how I am failing to understand the concept.

What I want is a 3-month rolling average on the price.

The table title tbl consisting of the following productID, priceMonth, Price

The SQL statement I am using is the following:

SELECT AVG(Price) over(partition by productID between 2 preceding and current row) 
as rolling_avg 
FROM tbl 
GROUP by priceMonth 
order by price

I am not sure if the syntax is correct as it is giving me the following error:

An alias was previously found. (near "rolling_avg").

Therefore I cordially ask you the following:

1) I cannot locate where the alias problem is, can I cordially ask your assistance?

2) Is the above sql statements addresses what I am looking for? i.e a 3month rolling average?

edited Jul 11 '17 at 21:07

asked Jul 11 '17 at 19:37

R.Cremona

2

Is this for MySQL or Microsoft SQL Server? – tadman Jul 11 '17 at 19:40
Hi tadam its for MySQL... apologies if I did not detail that aspect – R.Cremona Jul 11 '17 at 19:55
Please remove the sql-server tag if this is for MySQL. – Andrew O'Brien Jul 11 '17 at 19:59
While you're at it, remove the superfluous PHP tag too. – WillardSolutions Jul 11 '17 at 20:02
Removed both, thanks! – R.Cremona Jul 11 '17 at 20:07
Mysql does not support the `over` expression. – Shadow Jul 11 '17 at 20:17
dear shadow thanks this is already an indication, is there something similar in mySQL? – R.Cremona Jul 11 '17 at 21:09

3 month rolling/moving average

0 Answers0