July 25, 2012

Select query to get total # records for each day in a month

select day(DateField), count(*) from table where month(DateField) = month(NOW()) and year(DateField) = year(NOW()) group by day(DateField)

No comments:

Post a Comment

The Future of Technology: Emerging Trends to Watch in 2025

Introduction As we navigate through 2025, the technological landscape continues to evolve at an unprecedented pace. Innovations that once se...