Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: SQL Question

Re: Help: SQL Question

From: Pratap Kumar Tripathy <pktripathy_at_yahoo.com>
Date: 21 Jan 2002 04:47:41 -0800
Message-ID: <c6dd2b7.0201210447.390e4468@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US