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 records
SELECT * FROM sometable LIMIT 10,20 -ignores the first 10 records, returning the next 20.
Comments
Please sign in to leave a comment.