Select statement in SQLite recognizing row number

The automatically-created rowid for a table can be accessed by a few different names. From the SQLite documentation:

Every row of every SQLite table has a 64-bit signed integer key that uniquely identifies the row within its table. This integer is usually called the "rowid". The rowid value can be accessed using one of the special case-independent names "rowid", "oid", or "_rowid_" in place of a column name.

You want to use LIMIT and OFFSET

SELECT * FROM Table LIMIT 10 OFFSET 0

Which can also be expressed with the following shorthand syntax

SELECT * FROM Table LIMIT X,Y

Where X represents the offset, which is exclusive, and Y represents the quantity, so for example

SELECT * FROM Table LIMIT 50,50

Would return rows 51-100