You can create more complex queries by replacing the list of values in the IN or NOT IN clause with a subquery. The subquery can filter by ID (primary key) or reference (foreign key) fields.

IN または NOT IN 句内の値リストをサブクエリで置き換えることにより、より複雑なクエリを作成できます。 サブクエリでは、ID (主キー) 項目または参照 (外部キー) 項目で絞り込むこと …

Logical operators can be used in the field expression of the WHERE clause in a SOQL query. These operators are AND, OR, and NOT. Parentheses are required whenever you mix the …

Example WHERE Clauses ... See Also SOQL and SOSL reference: Date Formats and Date Literals in WHERE

Use null in WHERE You can search for null values by using the null keyword in SOQL queries. This example query returns the account IDs of all events with a non-null activity date.

SOQL doesn’t support all advanced features of the SQL SELECT command. For example, you can’t use SOQL to perform arbitrary join operations, use wildcards in field lists, or use …

Lightning uses auto-generated SOQL to retrieve fields for a record page layout, so the error can occur even if there isn’t any customer-written SOQL. The character limit can also be reached …

SOSL limits apply when executing SOSL queries. See Execution Governors and Limits. The 4,000 characters limit for WHERE clause strings doesn’t apply to SOQL queries in Apex if the …

Salesforce Object Query Language (SOQL) / SOQL SELECT Syntax / WHERE / Query Multi-Select Picklists

Strings in WHERE clauses can’t exceed 4,000 characters. This limit doesn’t apply to SOQL queries in Apex if the WHERE clause includes the IN operator.