7.33. Query Limit

• First

• Last

• Limit

• Offset

• Slice

7.33.1. First

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.first

>>> results = Valuation.query.filter_by(..).order_by(sqlalchemy.desc(Valuation.date)).first()

7.33.2. Last

• No last method

>>> results = Valuation.query.filter_by(..).order_by(sqlalchemy.desc(Valuation.date)).all()
>>> first_valuation = results[0]
>>> last_valuation = results[-1]

7.33.3. Limit

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.limit

7.33.4. Offset

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.offset

7.33.5. Slice

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.slice