I have the following table, sorted by pageNumer
, exerciseNumber
:
| uuid | pageNumber | exerciseNumber | name |
|--------------------------------------|------------|----------------|------|
| 31620782-5866-4198-a285-76cda9568f4d | 1 | 1 | a |
| 21abdcf6-a99f-4c73-825c-313e0eda2e02 | 2 | 3 | b |
| 6134609d-aedc-4385-9bf3-08c7a5514448 | 3 | 3 | c |
| a3d5d839-5fdd-4687-904a-9b0cbec11d68 | 3 | 4 | d |
I am selecting row with uuid
= 6134609d-aedc-4385-9bf3-08c7a5514448
,
how can I select before row and after row of selected row?
Normally I would do this by adding or subtracting 1 from id. But here I have uuid, which is not auto-increment :(
You must first add an id column
You can use this mode later:
next:
previous: