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

Home -> Community -> Usenet -> c.d.o.tools -> Counting rows

Counting rows

From: Clemens Pichl <clemens.pichl_at_schering.de>
Date: 4 Sep 2002 13:41:40 GMT
Message-ID: <Xns927F9FA8B16A6cpichl@130.149.4.16>

Hi,

For some statistics, I would like to generate a report with the number of entries in a table that have been added until a the end of each month. The number should always count from the beginning.

I tried the following:
select trunc(date_column, 'MONTH'), count(*) from tab
group by trunc(date_column, 'MONTH')

This is not sufficient, because the counts are not cumulative.

Any suggestion?

Thnx in advance,
Clemens Received on Wed Sep 04 2002 - 08:41:40 CDT

Original text of this message

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