By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| GID | V1 | V2 | LKP_FIRST | LKP_LASTMIN | LKP_LASTMAX |
|---|---|---|---|---|---|
| 1 | a | 2 | d | b | b |
| 1 | d | 1 | d | b | b |
| 1 | b | 3 | d | b | b |
| 2 | z | 8 | x | v | y |
| 2 | y | 9 | x | v | y |
| 2 | v | 9 | x | v | y |
| 2 | x | 7 | x | v | y |
| GID | LKP_FIRST | LKP_LASTMIN | LKP_LASTMAX |
|---|---|---|---|
| 1 | d | b | b |
| 2 | x | v | y |