SOQL query builder

A SOQL query lists the fields, the object, and an optional filter for Account, Contact, Opportunity, Case, or Lead. This builder uses a small local field list, shows a query you can copy, and does not connect to an org.

Objects: Account, Contact, Opportunity, Case, Lead.

Sample query

SELECT Id, Name
FROM Account

• Account: Practice this on Query one Account
• Contact: Practice this on Find missing Contact emails
• Opportunity: Practice this on Summarize Opportunity amounts
• Case: Practice SOQL on Query one Account
• Lead: Practice SOQL on Query one Account