Add the values of previous and current row only

See more:

SQL

server

Table Name is Employee

EmpNo EmpName Salary
1 A 2000
2 B 1000
3 C 3000
4 D 2000
5 E 5000

I need to get one more column by adding salary of previous and current row as

NewSal
2000
3000
4000
5000
7000

What I have tried:

Select EmpNo,
EmpName, Salary,(SELECT SUM(salary) FROM Employee e1 WHERE
e1.EmpNo <= e2.EmpNo)as T_Sal
FROM Employee e2

I tried this query but this is giving me the addition of all previous rows