Aniket Narvankar
This is one of the Interview Question Ask in one of MNC Company Interviewt bl1 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.
By Aniket Narvankar in SQL on Dec 16 2016
  • Sweet Chime
    Sep, 2018 6

    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

    • 1
  • Sai Reddy
    May, 2018 28

    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

    • 1
  • Sushobhit  Raman
    Nov, 2017 7

    select Id,sum(Sal) over(order by Id)AS SAL from @tbl

    • 1
  • Sushobhit  Raman
    Nov, 2017 7

    select Id,sum(Sal) over(order by Id)AS SAL from @tbl

    • 1
  • Sai Reddy
    May, 2018 28

    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

    • 0
  • Aniket Narvankar
    Dec, 2016 16

    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

    • 0

Most Popular Job Functions


MOST LIKED QUESTIONS