Example: GROUP BY in SOQL

Problem:

The VP of Sales would like to know how many Opportunities have the Lead Source of ‘Word of Mouth’. Additionally, she would like the number broken down by the Stage.

Solution:

Use the sample syntax below to write a SOQL query using GROUP BY.

SELECT COUNT(Id), StageName FROM Opportunity WHERE LeadSource= 'Word of Mouth' GROUP BY StageName

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top