📄️ SELECT
Specify fields that will be retrieved via query. Check SOQL API - SELECT.
📄️ SUBQUERY
Specify child relationship name and pass list of fields.
📄️ USING SCOPE
Get records within a specified scope.
📄️ WHERE
Use SOQL.FilterGroup and Use SOQL.Filter to build your WHERE clause.
📄️ GROUP BY
Group of records instead of processing many individual records.
📄️ ORDER BY
Control the order of the query results.
📄️ LIMIT
Specify the maximum number of rows to return.
📄️ OFFSET
Efficient way to handle large results sets.
📄️ Field Level Security
Enforce or bypass FLS.
📄️ Sharing
Control sharing rules behavior.
📄️ Mocking
Mock SOQL results in Unit Tests.
📄️ Debug
See query String in debug logs.
📄️ Result
Execut SOQL and get results.