Yearly Totals in MySQL

posted on Jan 21, 2010 at 5:01 p.m. EST in

count,
database,
db,
mysql,
select

SELECT 
      MONTHNAME(createDt) AS month,
      YEAR(createDt) AS year,
      COUNT(*) AS total
FROM tracking
GROUP BY MONTH(createDt), YEAR(createDt)
ORDER BY id

sql

SELECT 
      MONTHNAME(createDt) AS month,
      YEAR(createDt) AS year,
      COUNT(*) AS total
FROM tracking
GROUP BY MONTH(createDt), YEAR(createDt)
ORDER BY id

copy | embed

Public snipts » robertbanh's snipts » Count Monthly/Yearly Totals in MySQL

0 Comments