4
Reply
Reply

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

Aniket Narvankar
Dec 16, 2016
571
0
    ram ramesh

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

    ram ramesh
    August 07, 2017
    3
    ram ramesh

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

    ram ramesh
    August 07, 2017
    2
    kakku singh

    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
    March 16, 2017
    1
    Aniket Narvankar

    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
    December 16, 2016
    1