By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
| name | value | anothercolumn | max |
|---|---|---|---|
| Pump 1 | 8000 | Something1 | 10000 |
| Pump 1 | 10000 | Something2 | 10000 |
| Pump 1 | 10000 | Something3 | 10000 |
| Pump 2 | 3043 | Something4 | 6165 |
| Pump 2 | 4594 | Something5 | 6165 |
| Pump 2 | 6165 | Something6 | 6165 |
SELECT 6