Group by month and year in MySQL

by 
GROUP BY YEAR(t.summaryDateTime), MONTH(t.summaryDateTime);

is what you want.

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. Comparing date ranges
  3. Mysql: how to select groups having certain values?
  4. MySQL #1140 – Mixing of GROUP columns
  5. Selecting all corresponding fields using MAX and GROUP BY
  6. MySQL GROUP BY behavior
  7. Current date in Oracle Db
  8. Left Outer Join doesn’t return all rows from my left table?
  9. How to return only the Date from a SQL Server DateTime datatype
  10. MySQL Insert query doesn’t work with WHERE clause
  11. Delete from two tables in one query
  12. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  13. Delete sql rows where IDs do not have a match from another table
  14. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  15. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  16. MySQL equivalent of DECODE function in Oracle
  17. How do you version your database schema? [closed]
  18. Query comparing dates in SQL
  19. MySQL, Get users rank
  20. Get month name from date in Oracle
  21. How to fill date gaps in MySQL?
  22. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  23. Function for week of the month in mysql
  24. Comparing with date in Oracle sql
  25. what is the difference between GROUP BY and ORDER BY in sql
  26. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  27. Return number from Oracle Select statement after parsing date
  28. SQL query to group by day
  29. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  30. MySql bulk load command line tool

Leave a Comment