Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

count number of entires by months sql

select month(DepotArrivalDate), count(*)
from tbl_CMS_Container
WHERE     year(DepotArrivalDate) = '2013' 
group by month(DepotArrivalDate) 
Source by www.codeproject.com #
 
PREVIOUS NEXT
Tagged: #count #number #entires #months #sql
ADD COMMENT
Topic
Name
3+3 =