Subbarao-
Here it is. This will do the trick.
I sure do enjoy this stuff.
Chris

select to_char(xdt,'HH AM'), cnt
from
(
select to_date(to_char(creation_date,'HH24'),'HH24') xdt, count(*) cnt
from conc_requests
group by to_date(to_char(creation_date,'HH24'),'HH24')
)
order by to_char(xdt,'HH24')

TO_CH CNT

----- ----------

07 AM 3

08 AM 116

09 AM 33

10 AM 27

11 AM 33

12 PM 4

01 PM 33

02 PM 55

03 PM 42

04 PM 70

09 PM 6

1

12 rows selected.


Oracle LazyDBA home page