LIMIT

LIMIT is an optional clause that can be added to a SELECT statement to specify the maximum number of rows to return.

Syntax

SELECT fieldList
FROM objectType
[LIMIT numberOfRows]

For example:

SELECT Name
FROM User
LIMIT 10

This query returns the first 10 User records.