-
data by every hour
Hi guys, how do i get this
i want the count of cjobid for every hour,that is group by date(every hour) and by ctype for the last 3 days.below is the table structure.
can some one please help me.Thanks
customerjobs
-------------
cjobid number(10)
ctype varchar2(55)
cdate date
-
Group By to_char(cdate, 'YYYYMMDDHH24'), ctype
Or
Group By trunc(cdate, 'HH24'), ctype
Last edited by DaPi; 11-04-2004 at 10:38 AM.
-
thanks for the help .I will try this
ramana
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|