count

showing 1-1 of 1 snipts for count

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

0 comments - tagged in

count,
database,
db,
mysql,
select

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

A good read

MySQL Stored Procedure Programming

Public snipts » robertbanh's snipts » count

A good read

robertbanh's tags