Order By Id and Limit Offset By Id from a table
07:44 13 Jan 2020

I have an issue similar to the following query:

select name, number, id
from tableName
order by id 
limit 10 offset 5

But in this case I only take the 10 elements from the group with offset 5 Is there a way to set limit and offset by id?

For example if I have a set:

|------------------------------------|---|---------------------------------------|
| Ana                                | 1 | 589d0011-ef54-4708-a64a-f85228149651  |
| Jana                               | 2 | 589d0011-ef54-4708-a64a-f85228149651  |
| Jan                                | 3 | 589d0011-ef54-4708-a64a-f85228149651  |
| Joe                                | 2 | 64ed0011-ef54-4708-a64a-f85228149651  |

and if I have skip 1 I should get

|------------------------------------|---|---------------------------------------|
| Jana                               | 2 | 589d0011-ef54-4708-a64a-f85228149651  |
| Jan                                | 3 | 589d0011-ef54-4708-a64a-f85228149651  |
sql postgresql pagination sql-order-by limit