SELECT format(thedate,'d') AS e, count(*) AS ec
from products
Group by format(thedate,'d')
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL
SELECT YEAR(datefield) as year, MONTH(datefield) as month, DAY(datefield) as
day, COUNT(anotherfield) as nr
FROMtablename
WHERE datefield BETWEEN @start AND @end
GROUP BY YEAR(datefield), MONTH(datefield), DAY(datefield)
ORDER BY year, month, day
*should* work. The reason I split up the
2 matches
Mail list logo