You can limit the number of results returned by the TARGIT InMemory Database Server by adding a limit clause to the end of a query. There are two means to achieve the same results.
Example:
SELECT * FROM sometable LIMIT 10 returns the first 10 recordsSELECT * FROM sometable LIMIT 10,20 -ignores the first 10 records, returning the next 20.