Master the concepts of Salesforce in just 45 days Click here to know more.

8

DAYS :

10

HOURS :

58

MINS :

27

SECONDS
vote

SOQL Aggregate  Functions:

“SOQL Aggregate Functions” shows a calculated result from the query and returns AggregateResult.

Any query that includes an aggregate function returns its results in an array of AggregateResult objects. AggregateResult is a read-only sObject and is only used for query results.

1. Sum():

AggregateResult ar = [SELECT SUM(Max_Salary__c) 

FROM Position__c WHERE Max_Salary__c > 10000];

2. Max():

AggregateResult ar = [SELECT MAX(Max_Salary__c)

FROM Position__c 

WHERE Max_Salary__c > 10000];

3. Min():

AggregateResult ar = [SELECT MIN(Max_Salary__c)

FROM Position__c 

WHERE Max_Salary__c];

4. Count() and Count(fieldName):

Integer i = [SELECT count(ID) FROM Account];

5. Avg():

AggregateResult ar = [SELECT AVG(Min_Salary__c)

FROM Position__c 

WHERE Max_Salary__c < 5000];

6. Count_Distinct():

AggregateResult ar = [SELECT COUNT_DISTINCT(Name) 

FROM Position__c];

Cyntexa CTA

Our Recent Blog

Key Roles & Responsibilities Of A Salesforce Administrator

Key Roles & Responsibilities Of A Salesforce Administrator

19 Apr, 2022
Choosing a career as a Salesforce Administrator can be the best you can have because it will have a growing impact on the business.
Read More
How To Pass The Salesforce Developer Certification Exam?

How To Pass The Salesforce Developer Certification Exam?

17 Mar, 2022
Easy ways to crack salesforce developer program like learn basic coding, know prerequisites for salesforce developer certification, start practical exercises with trailhead.
Read More
Is Salesforce a Good Career?

Is Salesforce a Good Career?

01 Mar, 2022
Salesforce Developer Careers are on trending jobs across the globe. Start your career in Salesforce by taking Salesforce Developer Course, Admin Course.
Read More
Salesforce Career Choices In 2022 With Learning Path & Pay Scale

Salesforce Career Choices In 2022 With Learning Path & Pay Scale

27 Jan, 2022
There's no denying that the Salesforce economy is thriving right now. IDC predicts that 4.2 million jobs are being created...
Read More
The 2022 Salary Guide for Salesforce Developers

The 2022 Salary Guide for Salesforce Developers

25 Jan, 2022
Whenever a modern consumer needs more than simply a high-quality product or service, generating leads and converting them into loyal...
Read More
How To Pass The Salesforce Admin Certification Exam?

How To Pass The Salesforce Admin Certification Exam?

17 Jan, 2022
Salesforce is a critical component of the day-to-day operations of many businesses. The good news for Salesforce Admins is that...
Read More
Salary Guide Of Salesforce Consultant In 2022

Salary Guide Of Salesforce Consultant In 2022

13 Jan, 2022
Introduction: Before delving into the Consultancy part, let us understand what Salesforce is. Salesforce is the #1 CRM platform with...
Read More

Can I get a job by just learning Salesforce Admin?

30 Nov, 2021
In the 29th episode of the #AsktheHulk series Akarsh raised the question “Is there any opportunities for the Salesforce Admin?”
Read More
How the Salesforce Job Market is Growing

How the Salesforce Job Market is Growing

25 Nov, 2021
Introduction: Salesforce is considered to be the world’s most popular CRM platform while having at least a 20% market share,...
Read More
7 Best Salesforce Certifications In 2021

7 Best Salesforce Certifications In 2021

23 Nov, 2021
Introduction: Before moving towards the Best Salesforce Certification topic, let’s first understand about Salesforce, for those who are still unaware...
Read More
Share This Post
×