Count entries per month?

#1 (**permalink**) 01-30-2007, 04:36 PM

I have a table with a date_created column in it. I want to count the number of entries for every month. i.e
----------|------------
jan 2006 | 12
feb 2006 | 23

Hope you can help.

#2 (**permalink**) 01-30-2007, 05:31 PM

Guys, I have found the anwer myself, put though i would post it incase its of interest to anyone else:


SELECT MONTH(date_created), YEAR(date_created), COUNT(*)

FROM contact_requests 

GROUP BY MONTH(date_created), YEAR(date_created)

#3 (**permalink**) 03-06-2007, 01:28 AM


SELECT monthname(date_created),year(date_created),count(*  ) FROM TABLE

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

User Name		Remember Me?
Password

vBulletin Message

Cancel Changes

Count entries per month?

ANSWER(S):