Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Stackse 

RunningTotal

Language: Editor: Layout:
View schema
Execution time: 0,03 sec, rows selected: 60, rows affected: 15, absolute service time: 0,22 sec 
edit mode |  history
   SalesId Department SalesDate SalesAmount RunningTotal
1 1 DepartMent1 01.05.2016 00:00:00 50 50
2 2 DepartMent1 02.05.2016 00:00:00 20 70
3 3 DepartMent1 03.05.2016 00:00:00 30 100
4 4 DepartMent2 04.05.2016 00:00:00 150 250
5 5 DepartMent2 05.05.2016 00:00:00 110 360
6 6 DepartMent2 06.05.2016 00:00:00 120 480
7 7 DepartMent2 07.05.2016 00:00:00 10 490
8 8 DepartMent2 08.05.2016 00:00:00 20 510
9 9 DepartMent3 09.05.2016 00:00:00 40 550
10 10 DepartMent3 10.06.2016 00:00:00 50 600
11 11 DepartMent3 11.06.2016 00:00:00 60 660
12 12 DepartMent4 12.06.2016 00:00:00 70 730
13 13 DepartMent4 13.06.2016 00:00:00 80 810
14 14 DepartMent4 14.06.2016 00:00:00 90 900
15 15 DepartMent4 15.06.2016 00:00:00 180 1080
   SalesId Department SalesDate SalesAmount RunningTotal TotalSalesAmount
1 1 DepartMent1 01.05.2016 00:00:00 50 50 1080
2 2 DepartMent1 02.05.2016 00:00:00 20 70 1080
3 3 DepartMent1 03.05.2016 00:00:00 30 100 1080
4 4 DepartMent2 04.05.2016 00:00:00 150 250 1080
5 5 DepartMent2 05.05.2016 00:00:00 110 360 1080
6 6 DepartMent2 06.05.2016 00:00:00 120 480 1080
7 7 DepartMent2 07.05.2016 00:00:00 10 490 1080
8 8 DepartMent2 08.05.2016 00:00:00 20 510 1080
9 9 DepartMent3 09.05.2016 00:00:00 40 550 1080
10 10 DepartMent3 10.06.2016 00:00:00 50 600 1080
11 11 DepartMent3 11.06.2016 00:00:00 60 660 1080
12 12 DepartMent4 12.06.2016 00:00:00 70 730 1080
13 13 DepartMent4 13.06.2016 00:00:00 80 810 1080
14 14 DepartMent4 14.06.2016 00:00:00 90 900 1080
15 15 DepartMent4 15.06.2016 00:00:00 180 1080 1080
   SalesId Department SalesDate SalesAmount RunningTotal TotalSalesAmount PercentOfTotalSales
1 1 DepartMent1 01.05.2016 00:00:00 50 50 1080 4.63 %
2 2 DepartMent1 02.05.2016 00:00:00 20 70 1080 6.48 %
3 3 DepartMent1 03.05.2016 00:00:00 30 100 1080 9.26 %
4 4 DepartMent2 04.05.2016 00:00:00 150 250 1080 23.15 %
5 5 DepartMent2 05.05.2016 00:00:00 110 360 1080 33.33 %
6 6 DepartMent2 06.05.2016 00:00:00 120 480 1080 44.44 %
7 7 DepartMent2 07.05.2016 00:00:00 10 490 1080 45.37 %
8 8 DepartMent2 08.05.2016 00:00:00 20 510 1080 47.22 %
9 9 DepartMent3 09.05.2016 00:00:00 40 550 1080 50.93 %
10 10 DepartMent3 10.06.2016 00:00:00 50 600 1080 55.56 %
11 11 DepartMent3 11.06.2016 00:00:00 60 660 1080 61.11 %
12 12 DepartMent4 12.06.2016 00:00:00 70 730 1080 67.59 %
13 13 DepartMent4 13.06.2016 00:00:00 80 810 1080 75.00 %
14 14 DepartMent4 14.06.2016 00:00:00 90 900 1080 83.33 %
15 15 DepartMent4 15.06.2016 00:00:00 180 1080 1080 100.00 %
   SalesId Department SalesDate SalesAmount RunningTotal DepartmentRunningTotal
1 1 DepartMent1 01.05.2016 00:00:00 50 50 50
2 2 DepartMent1 02.05.2016 00:00:00 20 70 70
3 3 DepartMent1 03.05.2016 00:00:00 30 100 100
4 4 DepartMent2 04.05.2016 00:00:00 150 250 150
5 5 DepartMent2 05.05.2016 00:00:00 110 360 260
6 6 DepartMent2 06.05.2016 00:00:00 120 480 380
7 7 DepartMent2 07.05.2016 00:00:00 10 490 390
8 8 DepartMent2 08.05.2016 00:00:00 20 510 410
9 9 DepartMent3 09.05.2016 00:00:00 40 550 40
10 10 DepartMent3 10.06.2016 00:00:00 50 600 90
11 11 DepartMent3 11.06.2016 00:00:00 60 660 150
12 12 DepartMent4 12.06.2016 00:00:00 70 730 70
13 13 DepartMent4 13.06.2016 00:00:00 80 810 150
14 14 DepartMent4 14.06.2016 00:00:00 90 900 240
15 15 DepartMent4 15.06.2016 00:00:00 180 1080 420