mysql select sum group by date

by

This solution will give you the month name as a column of your resultset, followed by the total as required. 

SELECT MONTHNAME(o_date), SUM(total) 
FROM theTable
GROUP BY YEAR(o_date), MONTH(o_date)

More Related Contents:

  1. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  2. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  3. Sum results of a few queries and then find top 5 in SQL
  4. Recreating a query using INNER JOIN? [duplicate]
  5. Using LIMIT within GROUP BY to get N results per group?
  6. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  7. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  8. Retrieving the last record in each group – MySQL
  9. MySQL – Selecting a Column not in Group By
  10. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  11. MySQL Query – Records between Today and Last 30 Days
  12. Mysql query to dynamically convert rows to columns
  13. Ordering by specific field value first
  14. MySQL “Group By” and “Order By”
  15. INSERT INTO…SELECT for all MySQL columns
  16. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  17. SQL Query to get column values that correspond with MAX value of another column?
  18. Checking multiple columns for one value
  19. MySQL – How to search for exact word match using LIKE?
  20. MySQL – Fetching lowest value
  21. MySQL – How to select data by string length
  22. How to select the first row for each group in MySQL?
  23. MySQL GROUP BY DateTime +/- 3 seconds
  24. SELECT query return 1 row from each group
  25. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  26. MySQL Error: #1142 – SELECT command denied to user
  27. MySQL Group By Hours
  28. MySQL cumulative sum grouped by date
  29. MySQL Select Multiple VALUES
  30. SQL query with avg and group by

Leave a Comment