How does one go about iterating a table for the next largest primary key in a table that also has a specific secondary value?
Values to iterate with:
- uint64_t last_key_known == 1652645054;
- name user_value == User B;
Return row #5 only knowing the above.
row number (just for reference ) | uint64_t Primary Key | name Secondary Key |
---|---|---|
1 | 1652644680 | User A |
2 | 1652644682 | User A |
3 | 1652645054 | User B |
4 | 1652645056 | User C |
5 | 1652645059 | User B |
6 | 1652645060 | User A |