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.
SELECT * FROM sometable LIMIT 10 returns the first 10 records
SELECT * FROM sometable LIMIT 10,20 -ignores the first 10 records, returning the next 20.