How to skip records in SqlAlchemy query?

Question

I have 100 rows in my DB. I'm trying to execute select query but I want to skip the first 10 rows (i.e. I want rows in range 11-20).

How can I do this?

Study Limit offset and try to search before posting the question! — Intsab Haider
– Intsab Haider, Commented Oct 14, 2018 at 14:33

Hitobat · Accepted Answer · 2021-10-05 19:29:26Z

11

The raw SQL is like:

SELECT * FROM table LIMIT 10 OFFSET 10

In SqlAlchemy language it's like:

Table.query.limit(10).offset(10).all()

answered Oct 14, 2018 at 14:19

Hitobat

3,0771 gold badge19 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

This is SQL, not SQLAlchemy.

result = Doctors.query.all() - it's my query but this query fetchs all records. Can you write your query in this format? Thatns.

This is wrong, it should be Table.query.limit(10).offset(10).all()

Jim Stewart · Accepted Answer · 2018-10-14 14:25:07Z

3

You can use limit() and offset(), like this:

foos = session.query(Foo).offset(10).limit(10)

Which will construct a query like this:

select * from foos offset 10 limit 10

answered Oct 14, 2018 at 14:25

Jim Stewart

17.4k5 gold badges77 silver badges91 bronze badges