Thread: Problem counting records
View Single Post
  #3 (permalink)  
Old 2006-10-13, 05:40 PM
vladimir_cz vladimir_cz is offline
Senior Member
  
Join Date: Jul 2006
Location: Prague, Czech Republic
Posts: 193
vladimir_cz is on a distinguished road
Send a message via ICQ to vladimir_cz Send a message via MSN to vladimir_cz Send a message via Yahoo to vladimir_cz Send a message via Skype™ to vladimir_cz
Default
just for make your life simle, try to use grouping, something like this

select year(join_date),month(join_date),count(*) from table group by year(join_date),month(join_date)
__________________
Thank you. Vladimir, Czech Republic.
http://www.smartwebco.com/
I'm looking for job.
Reply With Quote