Can rollup help in this situation?

From: D. Alvarado <laredotornado_at_zipmail.com>
Date: 30 Jul 2004 05:45:19 -0700
Message-ID: <9fe1f2ad.0407300445.3caef245@posting.google.com>

Hi,

I have a table that records number of new registrants in a day. Some records may look like

DAY      NUM_REGISTRANTS
---      ---------------
1        10
2        5
3        8

I would like to create a SELECT statement such that I select the number of registrants per day, and the total number of registrants up to that point. Can I do that with SQL somehow? Ideally, a SELECT of the above data would yield

DAY        NUM_REGISTRANTS          TOTAL_REGISTRANTS
---        ---------------          -----------------
1          10                       10
2          5                        15
3          8                        23

Thanks for any advice, - Dave Received on Fri Jul 30 2004 - 07:45:19 CDT