列值总和直到当前记录

Question

How to do query and display the records with the sum of student money on every record?

 Student ID   Student Name   Student Money 
 ---------    -----------     --------------
   1           John            100
   2           Jenny           200
   3           Ben             100
   4           Andy            200
   5           Lynna           100

Above is my table and i would like to retrieve record in this format:

 Student ID   Student Name   Student Money     totalCounting 
 ---------    -----------     --------------   ---------
   1           John               100           100
   2           Jenny              200           300
   3           Ben                100           400
   4           Andy               200           600
   5           Lynna              100           700

Answer 1

Select s.*, (SELECT SUM(s2.`Money`) from students as s2 WHEre s2.`ID` = s.`ID`) as 'totalCounting' from students AS s;

Something like this.