Categories
MySQL

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

I got stuck writing a query for Firebird today. And here I was thinking that SQL was a standard — if only the “S” were 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: […]