Question 1:Write a query which will produce the below output ?
Solution - We can achieve the above situation by the following ways -
Query 1
Select
T0.ID
,T0.Num
,(Select SUM(Num) from #Temp T1 where T1.Id<=T0.ID) as Result
From #temp T0
Query 2
Select
T0.ID
,T0.Num
,SUM(T1.Num) as Result
from #Temp T0
Inner Join #Temp T1 on T1.Id<=T0.Id
Group by T0.ID ,T0.Num
0 Comments