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

Home -> Community -> Usenet -> c.d.o.server -> Help: how to group every 5 minutes?

Help: how to group every 5 minutes?

From: dbadba62 <dbadba62_at_hotmail.com>
Date: Wed, 18 Jul 2001 01:43:22 GMT
Message-ID: <3B54EB06.6E44F1AF@hotmail.com>

When I use

select entry_time, count(*) from foo group by entry_time;

it gives the results group by every seconds, could somebody tell me how to group by every 5 minutes?

Thank you very much for your help. Received on Tue Jul 17 2001 - 20:43:22 CDT

Original text of this message

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