General discussion
January 23, 2003 at 04:04 AM
michafri

Nested select

by michafri . Updated 23 years, 8 months ago

For this table:

START_TIME DATE
CHANNEL NUMBER(3)
CALL_TOT NUMBER
DUR_TOT NUMBER

… I use the query:

select to_char(start_time,’dd-MON-yy hh:mi:ss AM’), sum(call_tot)
from trasum
group by to_char(start_time,’dd-MON-yy hh:mi:ss AM’);

… to Sum the call totals of all channels with respect to each hour of the day (minutes and seconds aren’t counted).

Now, I want to see the Maximum call total for each day and the hour in which it falls. How mightI do that?

This discussion is locked

All Comments