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
Group By to_char(cdate, 'YYYYMMDDHH24'), ctype
Group By trunc(cdate, 'HH24'), ctype
Last edited by DaPi; 11-04-2004 at 09:38 AM.
thanks for the help .I will try this
Click Here to Expand Forum to Full Width