mardi 2 juin 2015

How to select specific row(s) in Sqlalchemy?

For example the method retrieves parameters page_size and skip (for paging), if skip has value = 2 and page_size has value = 10, then it means the selected rows will be from 21 onwards

How do you do that in sqlalchemy query? I have heard about LIMIT and OFFSET but I'm still lost in how to apply it in this case.

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire