The following are examples of text searches that use SOQL.
| Type of Search | Examples |
|---|---|
| Simple query | SELECT Id, Name, BillingCity FROM Account |
WHERE | SELECT Id FROM Contact WHERE Name LIKE 'A%' AND MailingCity = 'California' |
ORDER BY | SELECT Name FROM Account ORDER BY Name DESC NULLS LAST |
LIMIT | SELECT Name FROM Account WHERE Industry = 'media' LIMIT 125 |
ORDER BY with LIMIT | SELECT Name FROM Account WHERE Industry = 'media' ORDER BY BillingPostalCode ASC NULLS LAST LIMIT 125 |
count() | SELECT COUNT() FROM Contact |
GROUP BY | SELECT LeadSource, COUNT(Name) FROM Lead GROUP BY LeadSource |
HAVING | SELECT Name, COUNT(Id) FROM Account GROUP BY Name HAVING COUNT(Id) > 1 |
OFFSET with ORDER BY | SELECT Name, Id FROM Merchandise__c ORDER BY Name OFFSET 100 |
OFFSET with ORDER BY and LIMIT | SELECT Name, Id FROM Merchandise__c ORDER BY Name LIMIT 20 OFFSET 100 |
| Relationship queries: child-to-parent | SELECT Contact.FirstName, Contact.Account.Name FROM Contact |
| Relationship queries: parent-to-child | SELECT Name, (SELECT LastName FROM Contacts) FROM Account |
Relationship query with WHERE | SELECT Name, (SELECT LastName FROM Contacts WHERE CreatedBy.Alias = 'x') FROM Account WHERE Industry = 'media' |
| Relationship query: child-to parent with custom objects | SELECT Id, FirstName__c, Mother_of_Child__r.FirstName__c FROM Daughter__c WHERE Mother_of_Child__r.LastName__c LIKE 'C%' |
| Relationship query: parent to child with custom objects | SELECT Name, (SELECT Name FROM Line_Items__r) FROM Merchandise__c WHERE Name LIKE ‘Acme%’ |
| Relationship queries with polymorphic key | SELECT Id, Owner.Name FROM Task WHERE Owner.FirstName like 'B%' |
Polymorphic relationship queries using TYPEOF | SELECT TYPEOF What WHEN Account THEN Phone, NumberOfEmployees WHEN Opportunity THEN Amount, CloseDate ELSE Name, Email END FROM Event |
| Relationship queries with aggregate | SELECT Name, (SELECT CreatedBy.Name FROM Notes) FROM Account |
| Simple query: the UserId and LoginTime for each user | SELECT UserId, LoginTime from LoginHistory |
| Relationship queries with number of logins per user in a specific time range | SELECT UserId, COUNT(Id) from LoginHistory WHERE LoginTime > 2010-09-20T22:16:30.000Z AND LoginTime < 2010-09-21T22:16:30.000Z GROUP BY UserId |
| Query to retrieve the RecordType per user | SELECT Id, Name, IsActive, SobjectType, DeveloperName, Description FROM RecordType |
Additional relationship query example (child-to-parent):
1SELECT Id, Name, Account.Name FROM Contact
2WHERE Account.Industry = 'media'Additional relationship query example (parent-to-child):
1SELECT
2Account.Name, (SELECT Contact.LastName FROM Account.Contacts)
3FROM AccountAdditional relationship query examples with polymorphic key:
1SELECT Id, Who.FirstName, Who.LastName FROM Task WHERE
2Owner.FirstName LIKE 'B%'1SELECT Id, What.Name FROM
2EventAdditional relationship query example with aggregate:
1SELECT
2Amount, Id, Name, (SELECT Quantity, ListPrice,
3PricebookEntry.UnitPrice, PricebookEntry.Name FROM
4OpportunityLineItems) FROM OpportunityNote: If a user doesn’t have Read access to the object to which a record type belongs, that record type isn’t returned in the query results.
Apex requires that you surround SOQL and SOSL statements with square brackets to use them in your statements. You can use Apex script variables and expressions when preceded by a colon (:).
Note
j