Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: SQL Question
Hi,
Try this
select sum(count)
from t
group by floor(to_number(to_char(time,'MI'))/15)
cheers
pratap
Received on Mon Jan 21 2002 - 06:47:41 CST