I want to create a sql query for calculating the running total for each customer on a daily basis : I want to write a sql query for calculating the running total for each customer on a daily basis .
For example :
CustomerID   TranDate  TranAmount RunningTotal
==============================================
C1             8/1/17    $10        $10
===========================================
C2             8/1/17    $15        $15
========================================
C1             8/2/17    $20        $30
==========================================
C2             8/2/17    $30        $45
=============================================
C3             8/3/17    $50        $50
============================================
I was able to create running total If there is only 1 customer in the table but having difficulty when there are many .

Thank you in advance.
Please let me know if you need any further information .