Hi,

I have a table that includes the following fields, ID, start date,
start time, end date, end time and it includes a huge amount of
records (50 million) each representing a transaction completed in a
system.

What I would like to achieve is a list of dates and times along with
the number of records that fell during that time period. For example.

April 1, 00:00 - 01:00, 12000
April 1, 01:00 - 02:00, 100
etc

Is this possible in mysql or will I need to write a script to
complete?

I hope someone is able to help.

Thanks,
Iain

Iain Adams wrote:
I would say yes, but is beyond my instant capabilities to construct the
query..but the tools are all their in terms of functins and 'group by'
clauses.



or will I need to write a script to