// Results per page in pagination
SELECT id FROM cars LIMIT $criteria->offset,$criteria->limit
However, this does not work in MSSQL 2008 as it does not have support for LIMIT. Can you please advise how to do pagination with MSSQL? Note that using TOP is not interesting as that will only return the N defined number of results. What I need is to retrieve results between 1-10, 11-20 etc.