Calculating a Moving Average MySQL?

by

If you want the moving average for each date, then try this:

SELECT date, SUM(close),
       (select avg(close) from tbl t2 where t2.name_id = t.name_id and datediff(t2.date, t.date) <= 9
       ) as mvgAvg
FROM tbl t
WHERE date <= '2002-07-05' and
      name_id = 2
GROUP BY date
ORDER BY date DESC

It uses a correlated subquery to calculate the average of 9 values.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. How to select the nth row in a SQL database table?
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  6. Storing JSON in database vs. having a new column for each key
  7. How do I restore a dump file from mysqldump?
  8. Using an Alias in SQL Calculations
  9. Can a table field contain a hyphen?
  10. Adding a leading zero to some values in column in MySQL
  11. View’s SELECT contains a subquery in the FROM clause
  12. Check for x consecutive days – given timestamps in database
  13. MySQL Insert Into from one Database in another
  14. How do I get the ID of multiple inserted rows in MySQL?
  15. Does mysql have the equivalent of Oracle’s “analytic functions”?
  16. Case statement in MySQL
  17. MySQL: LAST_INSERT_ID() returns 0
  18. Remove special characters from a database field
  19. Using reserved words in column names
  20. MySQL query, MAX() + GROUP BY
  21. How to get multiple records against one record based on relation?
  22. MySQL – Replace Character in Columns
  23. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  24. FIND_IN_SET with multiple value [duplicate]
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. What is the difference between SQL and MySQL? [closed]
  27. How to use a user variables in MySQL LIKE clause?
  28. Selecting distinct 2 columns combination in mysql
  29. How to store a one to many relation in MySQL database?
  30. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;

Leave a Comment