Sum of Salary with Inner join

See more:

SQL-Server

I have a Table like this

Id	name	salary
1	A	100
2	B	200
3	A	100
4	C	700
5	D	600
6	C	700

I require this result using SQL query like this

name	salary	sumofsalary
A	100	100
B	200	300
A	100	400
C	700	1100
D	600	1700
C	700	2400

Please see every next row sum of salary is done with the all previous row salaries

I got the solution to get the required result with inner join but i am not able to understand the behavior of query. I mean how it is being done with inner join.

The query is:

select e.name,e.salary,sum(e2.Salary) sal
from Emp e inner join Emp e2
on e.Id>=e2.Id
group by e.Id,e.name,e.salary

Please help