Category Archives: SQL

SQL Access Equivalent MySQL Limit X, Y

In MySQL for paging a query we use SELECT * FROM {table} LIMIT X, Y In Access there is only SELECT TOP Y * FROM {table} to select first Y records of a query We can use this trick: First … Continue reading

Posted in Access, PHP, SQL | Tagged , , , , | Leave a comment