Thread: Why LIMIT and OFFSET are commutative

Why LIMIT and OFFSET are commutative

From
"Andrus"
Date:
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.