Multiple Averages

[Matrixkid]

Hi there,

 

I'm looking to get the AVG's of multiple rows, multiple times.

 

I want to get the AVG(price) from the last 10 rows, 20 rows, 50 rows, 100 rows, 200 rows

 

Is there a way to do this without having to use multiple SELECTS?

 

I was thinking maybe theres a way to pull the results using LIMIT 200, and then for each of the AVG's use that result set?

 

Simple table setup.

 

ID - Big Int,20

Price - Decimal 10,2

Entry_Time - Timestamp

 

Thanks,

MK

 

[fenway]

I suppose so -- you can use a row counter, and roll-your-own average.