Salesforce Object Query Language (SOQL)

Use the Salesforce Object Query Language (SOQL) to construct simple but powerful query strings for the queryString parameter in the query() call. Similar to the SELECT command in Structured Query Language (SQL), SOQL allows you to specify the source object (such as Account), a list of fields to retrieve, and conditions for selecting rows in the source object.

Note

SOQL does not support all advanced features of the SQL SELECT command. For example, you cannot use SOQL to perform arbitrary join operations, use wildcards in field lists, or use calculation expressions.

Use the following topics to understand the components of a SOQL SELECT, their syntax and usage:

SOQL Typographical Conventions
SELECT
Changing the Batch Size in Queries
toLabel()
Querying Currency Fields in Multicurrency Organizations
Date Formats and Date Literals
null
Filtering on Boolean Fields
Relationship Queries
Querying Multi-Select Picklists