Hmm, perhaps I didn't explain myself too well on the problem I'm having
with my database in my last post over a week ago. There's a table, which
contains a timestamp field, amongst others. How would I write a query
that does the following:
1. For each year, count all the records for that given year. There's
approximately 6 years' worth.
2. Within each year, for each month, count all the records that
matches the month (i.e. Feburary 2006).
How would I go about achieving that?
Take a nap, it saves lives....