Categories

PHP pagination: LIMIT in MySQL vs. FIRST / SKIP in FireBird

Firebird logo

I got stuck writing a query for Firebird today. And here I was thinking that SQL was a standard — if only the “S” was for “Standard”…

I was busy writing scripts at work to paginate results in our BI portals. In MySQL I would usually write something like this to return the first 20 records:

SELECT * FROM [...]