SQLite select x-th row

Question

let's suppose I have this table, where I deleted the row with rowid=3:

rowid | something
------+-----------
    1 | ...
    2 | ...
    4 | ...
    5 | ...

How to select the third row (the one with rowid=4) ?

Answer 1

select * from table limit 2,1

Means something like "start from index 2 and return 1 row."