Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculate rolling count

Sunny86Apr 4 2019 — edited Apr 7 2019

Dear all,

scenario

calculate rolled count(distinct Customers) from the beginning For example need to display like below

Report

MonthYEarNo of customers added in the month
Total Customers
JAN-201810      1010
FEB-2018 121022
MAR-2018  81030
---
----
FEB-2019   10    1260
MAR-2019      20 1280

Table Structure

Customer COdeDate
1001-JAN-2010
19811-FEB-2014
209012-APR-2018
This post has been answered by Frank Kulash on Apr 4 2019
Jump to Answer
Comments
Post Details
Added on Apr 4 2019
10 comments
409 views