Skip to content

japdubengsub/sql_challenge-2

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 

Repository files navigation

MS SQL Firt-In-First-Out (FIFO)

is calculated in one query without cursor
requires MSSQL 2012+

Problem Statement:

Simple banking account with accrual of interest on account amount.
Client may deposit some money and withdraw it at any time.
We need to calculate how many days the money was on deposit account before they have been withdrawn.

About

SQL challenge #2 (FIFO)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published