We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Cummulative or running total in SQL query

Lapchien
Lapchien asked
on
Medium Priority
707 Views
Last Modified: 2012-05-06
I have a table that I need to calculate the running total on, and I'm not sure how to work it out in the colum called CumulDaySales - that column need the running daily total from the Sales column.  Does anyone know how to calculate it?
Seq	Date	       DayTarget	CumulDayTgt     Sales         CumulDaysales
1	2009-02-01 	27	27	       15	            ?
2	2009-02-02 	27	54	       25	            ?
3	2009-02-03 	27	81	       21	            ?
4	2009-02-04 	27	108	       20	            ?
5	2009-02-05 	27	135	       17	            ?
6	2009-02-06 	27	162	       10	            ?
 
etc

Open in new window

Comment
Watch Question

Commented:
SELECT T1.Seq, T1.Date, T1.DayTarget, T1.CumulDayTgt, T1.Sales, CumulDaySales = (SELECT sum(T2.Sales) FROM <Table> T2 WHERE T2.Seq <= T1.Seq)
FROM <Table> T1

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.