By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1 (
`id` INTEGER,
`desc` VARCHAR(7),
`amount` DECIMAL(10,2)
);
✓
INSERT INTO table1
(`id`, `desc`, `amount`)
VALUES
('12345', 'Item 1', ' -228568.9'),
('12345', 'Item 2', ' -61734.3'),
('12345', 'Item 3', ' -532978.4'),
('12345', 'Item 4', ' -3193.7'),
('12345', 'Item 5', ' -4258.25'),
('12345', 'Item 6', ' 92189.85'),
('12345', 'Item 7', ' -1602.3'),
('12345', 'Item 8', ' -48746.25'),
('12345', 'Item 9', ' -61734.3'),
('12345', 'Item 10', '-11710.25'),
('12345', 'Item 11', '-0.05'),
('12345', 'Item 12', '-0.05'),
('12345', 'Item 13', '-0.05'),
('12345', 'Item 14', '-228568.9'),
('12345', 'Item 15', '-15968.6'),
('12345', 'Item 16', '-12774.85'),
('12345', 'Item 17', '-32306.75'),
('12345', 'Item 18', '-48746.25'),
('12345', 'Item 19', '213330.95'),
('12345', 'Item 21', '-15968.6'),
('12345', 'Item 22', '-0.05'),
('12345', 'Item 23', '45496.5'),
('12345', 'Item 24', '57618.65'),
('12345', 'Item 25', '497446.5'),
('12345', 'Item 26', '-0.05'),
('12345', 'Item 27', '-0.05'),
('12345', 'Item 28', '387874.5'),
('12345', 'Item 29', '14904'),
('12345', 'Item 30', '-0.05');
✓
SELECT id, SUM(amount) AS 'TOTAL PAID' FROM table1 GROUP BY ID;
| id | TOTAL PAID |
|---|---|
| 12345 | -5.355104831794577e-10 |