Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

how calculate running balanace acc -deposit-withdraw-sdata-

Home
Forums

how calculate running balanace acc -deposit-withdraw-sdata-

Manish kumar

9yAsked Nov 29, 2016, 1:38 AM814

how calculate running balanace acc -deposit-withdraw-sdata-

ANOTHER EXAMPLE FOR

CUSID-USER-ACCOUNT-AMOUNT--TYPE-BALANCE-SDATA

001-MANISH-454545-5000-DEPOSIT-5000-21/11/2016

002-MANISH-454545-3000-WITHDRAW-2000-23/11/2016

003-MANISH-454545-6000-DEPOSIT-8000-24/11/2016

004-MANISH-454545-2000-DEPOSIT-10000-24/11/2016

005-MANISH-454545-7000-WITHDRAW-3000-25/11/2016

plz post the SQl code for help us ,i am learner of java ,sql.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Manish Kumar9y ago
Accepted answer
Try this

create table ##transaction
(cusid int,username varchar(100),account int,amount float,type varchar(100),trandate datetime)

insert into ##transaction values (001,'manish',454545,5000,'DEPOSIT',getdate())
insert into ##transaction values (002,'manish',454545,3000,'WITHDRAW',getdate())
insert into ##transaction values (003,'manish',454545,6000,'DEPOSIT',getdate())
insert into ##transaction values (004,'manish',454545,2000,'DEPOSIT',getdate())
insert into ##transaction values (005,'manish',454545,7000,'WITHDRAW',getdate())

select cusid,username,amount,type,sum(case when type='DEPOSIT' then amount else case when type='WITHDRAW' then -amount end end) over (partition by account order by cusid) as balance
from ##transaction
Nitin Sontakke9y ago
Unfortunately, I may not be able to give the code, however, you will benefit from the following:

https://msdn.microsoft.com/en-us/library/hh231517.aspx

There are functions like LEAD, LAG which you can try. You may proceed with further search with the help of these function names.

Hope it helps!