SOQL guides and cheat sheets
Practical, copy-paste-ready references for querying Salesforce data — written by the team behind Inqua. No fluff: the syntax, the examples, and the gotchas that actually come up at work.
SOQL date literals: the complete cheat sheet
TODAY, LAST_N_DAYS, fiscal quarters, and absolute date formats — every literal with examples and gotchas.
FundamentalsSOQL vs SQL: the differences that trip everyone up
No SELECT *, no JOIN keyword, = null instead of IS NULL — the ten differences SQL people hit first.
FundamentalsJOINs in SOQL: how relationship queries work
Dot notation, parent-to-child subqueries, and semi-joins — the three SOQL patterns that replace SQL JOINs.
ReportingSOQL aggregate queries: GROUP BY, COUNT, SUM, and HAVING
Summarize pipeline, count by stage, and group by month with COUNT, SUM, AVG, GROUP BY, and HAVING.
How-toHow to count records in SOQL: COUNT(), COUNT(field), and COUNT_DISTINCT()
COUNT() vs COUNT(field) vs COUNT_DISTINCT — when to use each, plus counting by group and finding duplicates.
FundamentalsThe SOQL WHERE clause: operators, wildcards, and filters
Every comparison operator, LIKE wildcards, IN lists, INCLUDES, and null checks — with examples.
Learn SOQL by asking real questions
Inqua turns plain-English questions into live SOQL and shows the exact query behind every answer — the fastest way to learn the syntax is to see it written for you, against real data.
The demo runs on sample data — no Salesforce org required.