Decrese value on FIFO by primary SQL

Asked Feb 11 '22 at 14:02

Active Feb 11 '22 at 17:53

Viewed 62 times

I have tabels like this..

id	code	Name	Quantity
1	A1	ABC	10
2	A2	BCD	20
3	A1	ABC	30
4	A1	ABC	10
5	A3	EDC	30

i want to decrese quantity with this tabel..

code	Name	Quantity
A1	ABC	45
A2	BCD	5

then i want the result like this.

id	code	Name	Quantity
1	A1	ABC	0
2	A2	BCD	15
3	A1	ABC	0
4	A1	ABC	5
5	A3	EDC	30

i have no idea for this case. thanks..

edited Feb 11 '22 at 17:53

Progman

asked Feb 11 '22 at 14:02

10.4.22-MariaDB – Iyang Agung Supriatna Feb 11 '22 at 14:14
1

Cumulative sum in CTE and according decreasing. – Akina Feb 11 '22 at 14:15
CTE.? sorry what the meaning.? – Iyang Agung Supriatna Feb 11 '22 at 14:18
1

https://mariadb.com/kb/en/common-table-expressions/ and https://mariadb.com/kb/en/aggregate-functions-as-window-functions/ – Akina Feb 11 '22 at 14:19
ok ill try.. thanks – Iyang Agung Supriatna Feb 11 '22 at 14:21
how about using loop/for for this case.? – Iyang Agung Supriatna Feb 14 '22 at 03:33
Please show the code that you came up with, and explain the problem you might have with it. (I do think a loop can only be used in stored procedures, so you will have to write a stored procedure) – Luuk Feb 14 '22 at 08:03
sorry i can't explain.. but how is : https://dbfiddle.uk/?rdbms=mariadb_10.3&fiddle=44f0d7dbdb8f32c3a17b1a4e53f554cb – Iyang Agung Supriatna Feb 17 '22 at 08:08
my latest update, but capital price is keeping up with the latest stuff https://dbfiddle.uk/Thtq5FeV – Iyang Agung Supriatna Dec 17 '22 at 14:27

0 Answers0