I found that
SELECT * FROM fooORDER BY barOFFSET nLIMIT m
and
SELECT * FROM fooORDER BY barLIMIT mOFFSET n
produce always same results.
Why ?OFFSET and LIMIT operations are NOT commutative in general.
Andrus.