I found that
SELECT * FROM foo
ORDER BY bar
OFFSET n
LIMIT m
and
SELECT * FROM foo
ORDER BY bar
LIMIT m
OFFSET n
produce always same results.
Why ?
OFFSET and LIMIT operations are NOT commutative in general.
Andrus.
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.