This keyword limits the number of rows that are returned.  An optional offset can be specified as a second parameter. The offset is one based.

 

Example:

SELECT * FROM customers {maxrows 10}

This will return a maximum of 10 rows of data.

 

SELECT * FROM customers {maxrows 10,4}

This will return a maximum of 10 rows of data, starting at the 4th row of output.