This is one of the Interview Question Ask in one of MNC Company Interview tbl1 Id Sal 1 1000 2 2000 3 3000 Output Asked Was Id Sal 1 1000 2 3000 3 6000 For fist row Sal Should be same,for second row sum of first and second and third row sum of first,second and third?

Aniket Narvankar

606

select E_ID,sum(Salary) over(order by E_id) from EMP_SALARY

ram ramesh

select E_ID,sum(Salary) over(order by E_id)AS SALARY from EMP_SALARY

ram ramesh

declare @tbl Table (Id int,Sal numeric(10)) INSERT INTO @tbl (Id,Sal) VALUES (1,1000); INSERT INTO @tbl (Id,Sal) VALUES (2,2000); INSERT INTO @tbl (Id,Sal) VALUES (3,3000); Select a.Id,(Case when a.Id <> 0 then(Select Sum(Sal) from @tbl b where b.Id <= a.Id) end) as Sal from @tbl a order by a.Id

kakku singh

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

Aniket Narvankar