Hi All,
I am using Oracle 10g R2 on IBM AIX.
I need some assistance in building a query to fetch data from a table with the Count being split in Hourly Basis.
Something like below:-
SELECT count(*)
FROM EventsStore
WHERE create_date=20101201
AND create_time between 000000 and 010000;
Now the above will only return the count in the table for 1 hour. I need to get Count for every hour (from 000000 to 235959) in a single query. How can I achieve my aim ?
Thanks in advance.
Edited by: Sandyboy036 on Mar 7, 2011 11:01 PM