Force.com SOQL and SOSL Reference

Salesforce Object Query Language (SOQL)
SOQL Typographical Conventions
Quoted String Escape Sequences
Reserved Characters
SOQL SELECT Syntax
Condition Expression Syntax (WHERE Clause)
fieldExpression Syntax
USING SCOPE
ORDER BY
LIMIT
OFFSET
UPDATE TRACKING
UPDATE VIEWSTAT
WITH filteringExpression
GROUP BY
HAVING
TYPEOF
FORMAT ()
FOR VIEW
FOR REFERENCE
FOR UPDATE
Aggregate Functions
Date Functions
Querying Currency Fields in Multi-currency Orgs
Example SELECT Clauses
Relationship Queries
Change the Batch Size in Queries
SOQL Limits on Objects
Syndication Feed SOQL and Mapping Syntax
Location-Based SOQL Queries
Salesforce Object Search Language (SOSL)
PDF

Newer Version Available

This content describes an older version of this product. View Latest

LIMIT

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

The syntax for LIMIT is:

1SELECT fieldList
2FROM objectType
3[WHERE conditionExpression] 
4  [LIMIT numberOfRows]

For example:

1SELECT Name
2FROM Account
3WHERE Industry = 'Media' LIMIT 125

This query returns the first 125 Account records whose Industry is Media.

You can use LIMIT with count() as the fieldList to count up to the maximum specified.

You can't use a LIMIT clause in a query that uses an aggregate function, but does not use a GROUP BY clause. For example, the following query is invalid:

1SELECT MAX(CreatedDate)
2FROM Account LIMIT 1