What's the difference between
SELECT * FROM table LIMIT 50 OFFSET 5
SELECT * FROM table LIMIT 5,50
Is the second just a shorter version without using the OFFSET clause, or does writing is as an argument give better performance?
Asked
Active
Viewed 54 times
0
Colbs
- 587
- 10
- 25
-
The two are just alternative syntaxes for the same thing. – Gordon Linoff Nov 28 '18 at 21:37
-
No difference- and both of them are absent an ORDER BY clause, which renders them fairly meaningless – Strawberry Nov 28 '18 at 21:38
-
1They are alternative syntax for the same thing. I would argue that `OFFSET` always has bad performance, but that's another story. Use "key set" pagination if you can. – The Impaler Nov 28 '18 at 21:38
-
Also, please not that `OFFSET` without `ORDER BY` doesn't make any sense. – The Impaler Nov 28 '18 at 21:40