SQL Running Total

From: <porchdog_at_my-deja.com>
Date: 2000/04/27
Message-ID: <8e9ehr$qvs$1_at_nnrp1.deja.com>#1/1

I'm trying to write a query which will display a running total. For example, if a table has a day-of-the-week column, I want to display each day with a cumulative row total.

Detail Table

---

Row Day
--- ---

1      mon
2      mon
3      mon
4      tue
5      tue
6      wed

Desired Output

---

Day Total Rows
--- ----------

mon     3
tue     5
wed     6

Any ideas would be appreciated.

Tom

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 27 2000 - 00:00:00 CEST