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