offset

You can use offset clauses with the following queries:

• Objects

• Select

This will omit the first X rows from the response.

It’s highly recommended to use it along with an order_by clause, otherwise the results returned could be different each time.

>>> await Band.select(Band.name).offset(1).order_by(Band.name)
[{'name': 'Pythonistas'}, {'name': 'Rustaceans'}]

Likewise, with objects:

>>> await Band.objects().offset(1).order_by(Band.name)
[Band2, Band3]