SOQL (Salesforce Object Query Language) is one of the most essential skills for any Salesforce Developer or Admin. This cheat sheet covers all the key SOQL syntax, operators, relationship queries, aggregate functions, and governor limits you need for day-to-day development and certification exams. Basic SOQL Syntax The basic structure of a SOQL query is: SELECT field1, field2 FROM ObjectName WHERE condition ORDER BY field LIMIT n Example: SELECT Id, Name, Industry FROM Accoun

The entity type of every Salesforce record ID is encoded in its first three characters. The ID Field Type is a base-62 encoded string. 18-Character ID Encoding 0 0 0 1 1 2 3 3 3 3 3 3 3 3 3 4 4 4 0 0 0 : the object key prefix unique to the entity type. 1 1 : *Pod Identifier/ Instance Identifier 2 : Reserved for future system use. 3 3 3 3 3 3 3 3 3 : Unique alpha numeric identifier. 4 4 4 : Optional 3 character suffix to make Id's case-insensitive. 15-Character and 18-Charact