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!

Rolling unique person count by month over a time period

600493Sep 28 2007 — edited Sep 29 2007
Anyone have any idea how I could get a rolling count of the unique number of people that have purchased from a single query?

Month Person
Jan-07 A
Jan-07 B
Feb-07 A
Feb-07 C
Mar-07 D

Desired Output when run for Jan-March

Month Count
Jan-07 2
Feb-07 3
Mar-07 4
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2007
Added on Sep 28 2007
3 comments
11,162 views