Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
October 17, 2006, 2:39 pm
rate this thread
complicated queries but now I need to see if I can create a query that
will show me the busiest day in our helpdesk and return the date and
the number of calls.
We have a database with a table called tracking which has date fields.
I want to count all teh records for each day, and return date with the
highest count and the count itself...
I'm sure its possible but I'm stuck as to what to google for...
Re: Busiest day : Count records per day and show max
Thanks That works great !
Except I forgot to say that the date field (called date) is a date and
time field so the grouping doesn't work as all the calls were placed at
different times ! Can we order just by the date part of the datetime
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum