create database company go use company create table tbl1 ( Id INT Primary Key Identity, Sal INT(50) ) GOINSERT INTO tbl1 Values((1,1000),(2,2000),(3,3000)) select id, sum(sal) over(order by id) as sal_ from emp
Select a.id,a.salary,sum(b.salary) as salary from table a cross join table b where b.id<=a.id group by a.id,a.salary
select Id,sum(Sal) over(order by Id)AS SAL from @tbl
The query for above question:Select a.Id,(Case when a.Id <> 0 then(Select Sum(Sal) from tbl1 b where b.Id <= a.Id) end) as Sal from tbl1 a order by a.Id