SQL Code

TO_CHAR( Date_Stamp, 'HH24' ) Hour<= /DIV>

FROM

Table_Name

GROUP BY

Code,

TO_CHAR( Date_Stamp, 'HH24' ) Hour;=

It might take some processing to do the grouping by the To_Char (which= g ives the hour), but it should work.

Regards
Oweson=20 Flynn
------------------------------------------------------------------=
Certified=20 Oracle DBA
The Flynn Consultancy
Tel: 082-600-7-006
Fax: (011)=20 782-9313
EMail: oef@icon.co.za

----- Original Message -----
Fro= m:=20 Na= ik, Kevin=20 K

To: Multiple recipients of list ORACLE-L= =20

Sent: Friday, January 12, 2001 8:5= 5=20 AM

Subject: SQL Code

Hi All,

I have an interesting problem, lets say I have a table = with 2=20 fields, one with a code, and the other with a full datestamp, -+ 8 millio= n=20 records.

What will the SQL code be to query this table, to show = the=20 result - the count of all codes that occur between every hour for the day= ,=20 ie

5 counts of code type a, 6 of type b etc, between 01h00= and=20 02h00
7 counts of type a, 8 of b etc, between 0= 2h00=20 and 03h00 etc etc etc

Any ideas anybody ?
Thanx=20
Kevin N

______________________________________________

Disclaimer = and=20 confidentiality note

Everything in = this e-mail=20 and any attachments relating to the official business of Standard Bank=20 Investment Corporation= (Stanbic) is proprietary to the compan= y. It is=20 confidential, legally privileged and protected by law. Stanbic does not own=20 and endorse any other content. Views and opinions are those of the sender= unless clearly stated as being that of Stanbic.

The person add= ressed in the=20 e-mail is the sole authorised recipient. Please notify the sender immedia= tely=20 if it has unintentionally reached you and do not read, disclose or use th= e=20 content in any way.

Stanbic can not assure that the integrity of this communication has be= en=20 maintained nor that it is free of errors, virus, interception or=20 interference.

&nbs= p; _______________________________________________





********************************************************************



This message may contain information which is confidential and subject to l=
egal privilege. If you are not the intended recipient, you may not peruse, =
use, disseminate, distribute or copy this message. If you have received thi=
s message in error, please notify the sender immediately by email, facsimil=
e or telephone and return and/or destroy the original message.