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 |