Matrixkid Posted March 1, 2012 Share Posted March 1, 2012 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 Quote Link to comment https://forums.phpfreaks.com/topic/258061-multiple-averages/ Share on other sites More sharing options...
fenway Posted March 3, 2012 Share Posted March 3, 2012 I suppose so -- you can use a row counter, and roll-your-own average. Quote Link to comment https://forums.phpfreaks.com/topic/258061-multiple-averages/#findComment-1323496 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.