Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Counting rows
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