mercredi 27 avril 2016

about sqlite offset - What i do not understand?

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