Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL Query: Counting records by Time Interval
I have a table that tracks Request and Response data coming in and out
of a system from different systems. Easch transaction originates from
an external system, comes into the serving system as a Request (RQST),
is TimeStamped (RQST_TM) and a response is generated (RSPN) and the
response is TimeStamped (RPSN) and sent to the client system. Some of
the columns in the table are as follows:
ECTN CHARACTER 12 NOT NULLABLE TRX_TYPE CHARACTER 3 NOT NULLABLE RQST VARCHAR 600 NOT NULLABLE RQST_TM TIMESTAMP 10 NOT NULLABLE RSPN VARCHAR 600 NULLABLE RSPN_TM TIMESTAMP 10 NULLABLE ORIG_CD CHARACTER 2 NOT NULLABLE
I need to be able to view the number of requests (COUNT) that come in by hour intervals (for example between the hours of 8 and 9am, 9 and 10 am, 10 and 11am, etc) for a particular day and the peak time period the system recieves requests. Could someone help me?
Thanks,
Tim
Received on Mon Jun 25 2007 - 09:45:05 CDT