If you check SELECT sqlite clause: http://ift.tt/1MjSvfC
You will see OFFSET demands EXPR. to get correct result from your database query. And when I went checking what is EXPR. (Please see this: http://ift.tt/1pGeK7C) i see theoretically there should be a way to express a function after offset. For an example:
select * from my_table limit 50 offset count(id);
Count function would give you numeric value, however we know this is not possible. So my question is: Is there any way to add functions to offset or am I reading things in wrong way from links?
Aucun commentaire:
Enregistrer un commentaire