MySQL Forums
Forum List  »  Serbian/Croatian/Bosnian

Sumiranje - Kaskadno
Posted by: Srdjan Mish
Date: July 16, 2018 04:07AM

Poštovani,

imam jedan problem, pa mi treba pomoć. Što se tiče MySQL, nisam super napredni korisnik, ali imam dovoljno znanja da radim puno stvari.

Naime, imam jednu tabelu koja sadrži promene, u numeričkom obliku, nekog objekta. Potrebno mi je da povučem upitom sumu po redu, kako bih, za određeni trenutak, znao koliko je ukupno preostalo, količinski, tog objekta... Na primer:

1. Tabela sadrži kolone DATUM, Oznaka, Ulaz, Izlaz
2. Podaci su primera:

2018-07-01 A001 100 0
2018-07-03 X001 0 5
2018-07-04 X002 0 9
2018-07-07 A002 6 0
2018-07-08 X003 0 13
.
.
.


Meni treba da dobijem sledeće (ako uzmemo u obzir da mi treba do datuma 07.07.2018) - dodatna kolona koja se zove STANJE

2018-07-01 A001 100 0 100
2018-07-03 X001 0 5 95
2018-07-04 X002 0 9 86
2018-07-07 A002 6 0 92

Options: ReplyQuote


Subject
Views
Written By
Posted
Sumiranje - Kaskadno
1921
July 16, 2018 04:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.