MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


10.3.32-MariaDB


CREATE TABLE t (
  id INT PRIMARY KEY,
  amount INT NOT NULL
);
INSERT INTO t VALUES
(1  , 100  ),
(2  , 0    ),
(3  , 0    ),
(4  , 200  ),
(5  , 0    ),
(6  , 0    ),
(7  , 0    ),
(8  , 300  ),
(9  , 0    );
WITH v AS (
 SELECT *, SUM(amount) OVER(ORDER BY id ASC) sum_amount, MAX(amount) OVER(ORDER BY id ASC) max_amount
 FROM t
)
SELECT id, amount
FROM v
WHERE sum_amount > 0 AND sum_amount = max_amount


id
amount


1
100

2
0

3
0


 SELECT *, SUM(amount) OVER(ORDER BY id ASC) sum_amount, MAX(amount) OVER(ORDER BY id ASC) max_amount
 FROM t


id
amount
sum_amount
max_amount


1
100
100
100

2
0
100
100

3
0
100
100

4
200
300
200

5
0
300
200

6
0
300
200

7
0
300
200

8
300
600
300

9
0
600
300

id	amount	sum_amount	max_amount
1	100	100	100
2	0	100	100
3	0	100	100
4	200	300	200
5	0	300	200
6	0	300	200
7	0	300	200
8	300	600	300
9	0	600	300

id	amount	sum_amount	max_amount
1	100	100	100
2	0	100	100
3	0	100	100
4	200	300	200
5	0	300	200
6	0	300	200
7	0	300	200
8	300	600	300
9	0	600	300

id	amount	sum_amount	max_amount
1	100	100	100
2	0	100	100
3	0	100	100
4	200	300	200
5	0	300	200
6	0	300	200
7	0	300	200
8	300	600	300
9	0	600	300