By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 10.23 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-15), 64-bit |
SELECT 1
| id | line_id |
|---|---|
| 30 | 1 |
| 40 | 1 |
| 60 | 2 |
| 70 | 2 |
SELECT 4