Select id,name,salary,(select SUM(salary) from emp e1 where e1.id<=e2.id) as Runningtotal
from emp e2
How to find Running Total Salary in SQL Server?
Select id,name,salary,(select SUM(salary) from emp e1 where e1.id<=e2.id) as Runningtotal
from emp e2
Hi all friends, I think working with DotNet technologies is quite good. Some of them are sharing with you, which will help a lot to get a good job and to make the interview worthy. Best wishes.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment