Subject | Group by on a timestamp field |
---|---|
Author | williamvdw2004 |
Post date | 2005-02-03T10:09Z |
Hi
I have a database that logs messages and the time they where sent.
I am trying get the "messages per minute" rate.
Here is a sample of my current sql statment (which seems to return
messages per second).
select timesent,count(*) from messages group by timesent
Regards
William
I have a database that logs messages and the time they where sent.
I am trying get the "messages per minute" rate.
Here is a sample of my current sql statment (which seems to return
messages per second).
select timesent,count(*) from messages group by timesent
Regards
William