Обсуждение: Why LIMIT and OFFSET are commutative

Поиск
Список
Период
Сортировка

Why LIMIT and OFFSET are commutative

От
"Andrus"
Дата:
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.