This keyword limits the number of rows that are returned.

 

Example:

SELECT * FROM customers {maxrows #}